{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                 持买仓量\n",
      "date       variety 持买仓量期货公司          \n",
      "2018-10-22 A       永安期货        7337.0\n",
      "           AG      永安期货       12358.0\n",
      "           AL      永安期货        9945.0\n",
      "           AP      永安期货        4755.0\n",
      "           AU      永安期货        3237.0\n",
      "           B       永安期货        1339.0\n",
      "           BU      永安期货       36355.0\n",
      "           C       永安期货       25830.0\n",
      "           CF      永安期货       17115.0\n",
      "           CS      永安期货        4092.0\n",
      "           CU      永安期货        9853.0\n",
      "           CY      永安期货           8.0\n",
      "           FG      永安期货       17941.0\n",
      "           FU      永安期货        4139.0\n",
      "           HC      永安期货       38061.0\n",
      "           I       永安期货        9483.0\n",
      "           IC      永安期货         999.0\n",
      "           IF      永安期货        1993.0\n",
      "           IH      永安期货         403.0\n",
      "           J       永安期货        8508.0\n",
      "           JD      永安期货        5644.0\n",
      "           JM      永安期货       12420.0\n",
      "           JR      永安期货          30.0\n",
      "           L       永安期货       29558.0\n",
      "           M       永安期货      267273.0\n",
      "           MA      永安期货       28139.0\n",
      "           NI      永安期货       11686.0\n",
      "           OI      永安期货       10240.0\n",
      "           P       永安期货       10969.0\n",
      "           PB      永安期货        5204.0\n",
      "           PM      永安期货           0.0\n",
      "           PP      永安期货       37780.0\n",
      "           PTA     永安期货       43258.0\n",
      "           RB      永安期货      115428.0\n",
      "           RM      永安期货       17074.0\n",
      "           RU      永安期货        9581.0\n",
      "           SF      永安期货        1839.0\n",
      "           SM      永安期货        1649.0\n",
      "           SN      永安期货         217.0\n",
      "           SR      永安期货       13036.0\n",
      "           T       永安期货        9031.0\n",
      "           TF      永安期货        1313.0\n",
      "           V       永安期货       14866.0\n",
      "           WH      永安期货          96.0\n",
      "           Y       永安期货       90573.0\n",
      "           ZC      永安期货        4059.0\n",
      "           ZN      永安期货       12739.0\n",
      "                                 持卖仓量\n",
      "date       variety 持卖仓量期货公司          \n",
      "2018-10-22 A       永安期货        7666.0\n",
      "           AG      永安期货       12086.0\n",
      "           AL      永安期货       13570.0\n",
      "           AP      永安期货        8880.0\n",
      "           AU      永安期货         851.0\n",
      "           B       永安期货        2598.0\n",
      "           BU      永安期货       22100.0\n",
      "           C       永安期货       99637.0\n",
      "           CF      永安期货       25820.0\n",
      "           CS      永安期货        5641.0\n",
      "           CU      永安期货        8097.0\n",
      "           CY      永安期货          31.0\n",
      "           FG      永安期货       15942.0\n",
      "           FU      永安期货        5940.0\n",
      "           HC      永安期货       57489.0\n",
      "           I       永安期货       28864.0\n",
      "           IC      永安期货        2300.0\n",
      "           IF      永安期货        1376.0\n",
      "           J       永安期货        9861.0\n",
      "           JD      永安期货        4753.0\n",
      "           JM      永安期货        5765.0\n",
      "           JR      永安期货          28.0\n",
      "           L       永安期货       39290.0\n",
      "           LR      永安期货         254.0\n",
      "           M       永安期货      111000.0\n",
      "           MA      永安期货       32606.0\n",
      "           NI      永安期货       19401.0\n",
      "           OI      永安期货       11467.0\n",
      "           P       永安期货       40928.0\n",
      "           PB      永安期货         555.0\n",
      "           PM      永安期货           4.0\n",
      "           PP      永安期货       28092.0\n",
      "           PTA     永安期货       80116.0\n",
      "           RB      永安期货      192621.0\n",
      "           RM      永安期货       48654.0\n",
      "           RU      永安期货       17400.0\n",
      "           SF      永安期货        7421.0\n",
      "           SM      永安期货        2292.0\n",
      "           SN      永安期货         404.0\n",
      "           SR      永安期货       15454.0\n",
      "           T       永安期货        5613.0\n",
      "           TF      永安期货        2729.0\n",
      "           V       永安期货       29910.0\n",
      "           WH      永安期货         746.0\n",
      "           Y       永安期货       25633.0\n",
      "           ZC      永安期货       10690.0\n",
      "           ZN      永安期货       10445.0\n",
      "          date variety  会员简称      持买仓量      持卖仓量       净持仓\n",
      "0   2018-10-22       A  永安期货    7337.0    7666.0    -329.0\n",
      "1   2018-10-22      AG  永安期货   12358.0   12086.0     272.0\n",
      "2   2018-10-22      AL  永安期货    9945.0   13570.0   -3625.0\n",
      "3   2018-10-22      AP  永安期货    4755.0    8880.0   -4125.0\n",
      "4   2018-10-22      AU  永安期货    3237.0     851.0    2386.0\n",
      "5   2018-10-22       B  永安期货    1339.0    2598.0   -1259.0\n",
      "6   2018-10-22      BU  永安期货   36355.0   22100.0   14255.0\n",
      "7   2018-10-22       C  永安期货   25830.0   99637.0  -73807.0\n",
      "8   2018-10-22      CF  永安期货   17115.0   25820.0   -8705.0\n",
      "9   2018-10-22      CS  永安期货    4092.0    5641.0   -1549.0\n",
      "10  2018-10-22      CU  永安期货    9853.0    8097.0    1756.0\n",
      "11  2018-10-22      CY  永安期货       8.0      31.0     -23.0\n",
      "12  2018-10-22      FG  永安期货   17941.0   15942.0    1999.0\n",
      "13  2018-10-22      FU  永安期货    4139.0    5940.0   -1801.0\n",
      "14  2018-10-22      HC  永安期货   38061.0   57489.0  -19428.0\n",
      "15  2018-10-22       I  永安期货    9483.0   28864.0  -19381.0\n",
      "16  2018-10-22      IC  永安期货     999.0    2300.0   -1301.0\n",
      "17  2018-10-22      IF  永安期货    1993.0    1376.0     617.0\n",
      "18  2018-10-22      IH  永安期货     403.0       0.0     403.0\n",
      "19  2018-10-22       J  永安期货    8508.0    9861.0   -1353.0\n",
      "20  2018-10-22      JD  永安期货    5644.0    4753.0     891.0\n",
      "21  2018-10-22      JM  永安期货   12420.0    5765.0    6655.0\n",
      "22  2018-10-22      JR  永安期货      30.0      28.0       2.0\n",
      "23  2018-10-22       L  永安期货   29558.0   39290.0   -9732.0\n",
      "24  2018-10-22       M  永安期货  267273.0  111000.0  156273.0\n",
      "25  2018-10-22      MA  永安期货   28139.0   32606.0   -4467.0\n",
      "26  2018-10-22      NI  永安期货   11686.0   19401.0   -7715.0\n",
      "27  2018-10-22      OI  永安期货   10240.0   11467.0   -1227.0\n",
      "28  2018-10-22       P  永安期货   10969.0   40928.0  -29959.0\n",
      "29  2018-10-22      PB  永安期货    5204.0     555.0    4649.0\n",
      "30  2018-10-22      PM  永安期货       0.0       4.0      -4.0\n",
      "31  2018-10-22      PP  永安期货   37780.0   28092.0    9688.0\n",
      "32  2018-10-22     PTA  永安期货   43258.0   80116.0  -36858.0\n",
      "33  2018-10-22      RB  永安期货  115428.0  192621.0  -77193.0\n",
      "34  2018-10-22      RM  永安期货   17074.0   48654.0  -31580.0\n",
      "35  2018-10-22      RU  永安期货    9581.0   17400.0   -7819.0\n",
      "36  2018-10-22      SF  永安期货    1839.0    7421.0   -5582.0\n",
      "37  2018-10-22      SM  永安期货    1649.0    2292.0    -643.0\n",
      "38  2018-10-22      SN  永安期货     217.0     404.0    -187.0\n",
      "39  2018-10-22      SR  永安期货   13036.0   15454.0   -2418.0\n",
      "40  2018-10-22       T  永安期货    9031.0    5613.0    3418.0\n",
      "41  2018-10-22      TF  永安期货    1313.0    2729.0   -1416.0\n",
      "42  2018-10-22       V  永安期货   14866.0   29910.0  -15044.0\n",
      "43  2018-10-22      WH  永安期货      96.0     746.0    -650.0\n",
      "44  2018-10-22       Y  永安期货   90573.0   25633.0   64940.0\n",
      "45  2018-10-22      ZC  永安期货    4059.0   10690.0   -6631.0\n",
      "46  2018-10-22      ZN  永安期货   12739.0   10445.0    2294.0\n",
      "47  2018-10-22      LR  永安期货       0.0     254.0    -254.0\n",
      "          date variety  contractValue\n",
      "0   2018-10-22       A        37230.0\n",
      "1   2018-10-22      AG        53460.0\n",
      "2   2018-10-22      AL        70855.0\n",
      "3   2018-10-22      AP       105810.0\n",
      "4   2018-10-22      AU       276000.0\n",
      "5   2018-10-22       B        34800.0\n",
      "6   2018-10-22      BU        36550.0\n",
      "7   2018-10-22       C        19150.0\n",
      "8   2018-10-22      CF        77735.0\n",
      "9   2018-10-22      CS        24040.0\n",
      "10  2018-10-22      CU       252375.0\n",
      "11  2018-10-22      CY       121880.0\n",
      "12  2018-10-22      FB        50500.0\n",
      "13  2018-10-22      FG        26460.0\n",
      "14  2018-10-22      FU        35600.0\n",
      "15  2018-10-22      HC        38840.0\n",
      "16  2018-10-22       I        52400.0\n",
      "17  2018-10-22      IC       862000.0\n",
      "18  2018-10-22      IF       986700.0\n",
      "19  2018-10-22      IH       765900.0\n",
      "20  2018-10-22       J       235700.0\n",
      "21  2018-10-22      JD        42170.0\n",
      "22  2018-10-22      JM        81600.0\n",
      "23  2018-10-22      JR        58660.0\n",
      "24  2018-10-22       L        47105.0\n",
      "25  2018-10-22      LR        54200.0\n",
      "26  2018-10-22       M        33070.0\n",
      "27  2018-10-22      MA        33180.0\n",
      "28  2018-10-22      NI       104238.0\n",
      "29  2018-10-22      OI        67420.0\n",
      "30  2018-10-22       P        48060.0\n",
      "31  2018-10-22      PB        91730.0\n",
      "32  2018-10-22      PM       127000.0\n",
      "33  2018-10-22      PP        50030.0\n",
      "34  2018-10-22      RB        41330.0\n",
      "35  2018-10-22      RI        46600.0\n",
      "36  2018-10-22      RM        24990.0\n",
      "37  2018-10-22      RU        60465.0\n",
      "38  2018-10-22      SF        34270.0\n",
      "39  2018-10-22      SM        43925.0\n",
      "40  2018-10-22      SN       147420.0\n",
      "41  2018-10-22      SR        52060.0\n",
      "42  2018-10-22       T       950000.0\n",
      "43  2018-10-22     PTA        34670.0\n",
      "44  2018-10-22      TF       980000.0\n",
      "45  2018-10-22      TS      1980000.0\n",
      "46  2018-10-22       V        32185.0\n",
      "47  2018-10-22      WH        51040.0\n",
      "48  2018-10-22      WR        40020.0\n",
      "49  2018-10-22       Y        57990.0\n",
      "50  2018-10-22      ZC        63400.0\n",
      "51  2018-10-22      ZN       110660.0\n",
      "   variety         净持仓价值\n",
      "33      RB -3.190387e+09\n",
      "28       P -1.439830e+09\n",
      "7        C -1.413404e+09\n",
      "41      TF -1.387680e+09\n",
      "32     PTA -1.277867e+09\n",
      "16      IC -1.121462e+09\n",
      "15       I -1.015564e+09\n",
      "26      NI -8.041962e+08\n",
      "34      RM -7.891842e+08\n",
      "14      HC -7.545835e+08\n",
      "8       CF -6.766832e+08\n",
      "42       V -4.841911e+08\n",
      "35      RU -4.727758e+08\n",
      "23       L -4.584259e+08\n",
      "3       AP -4.364662e+08\n",
      "45      ZC -4.204054e+08\n",
      "19       J -3.189021e+08\n",
      "2       AL -2.568494e+08\n",
      "36      SF -1.912951e+08\n",
      "25      MA -1.482151e+08\n",
      "39      SR -1.258811e+08\n",
      "27      OI -8.272434e+07\n",
      "13      FU -6.411560e+07\n",
      "5        B -4.381320e+07\n",
      "9       CS -3.723796e+07\n",
      "43      WH -3.317600e+07\n",
      "37      SM -2.824378e+07\n",
      "38      SN -2.756754e+07\n",
      "47      LR -1.376680e+07\n",
      "0        A -1.224867e+07\n",
      "11      CY -2.803240e+06\n",
      "30      PM -5.080000e+05\n",
      "22      JR  1.173200e+05\n",
      "1       AG  1.454112e+07\n",
      "20      JD  3.757347e+07\n",
      "12      FG  5.289354e+07\n",
      "46      ZN  2.538540e+08\n",
      "18      IH  3.086577e+08\n",
      "29      PB  4.264528e+08\n",
      "10      CU  4.431705e+08\n",
      "31      PP  4.846906e+08\n",
      "6       BU  5.210202e+08\n",
      "21      JM  5.430480e+08\n",
      "17      IF  6.087939e+08\n",
      "4       AU  6.585360e+08\n",
      "40       T  3.247100e+09\n",
      "44       Y  3.765871e+09\n",
      "24       M  5.167948e+09\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABH4AAAOlCAYAAAAb6yB7AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAIABJREFUeJzs3Xu03WV95/HPkwtJRHRsQJCJEOw4NazqIGa0XnsIwQuggrMQlshQaRdjK9QywjKhdVYqVeOFLqeIuhi1ZViuMQVpp4i1XAShUhQQM1RCrSjYdIlCqtASzPWZP84hTTSU7JN9spNvXq+/ztn72b/z3XutTQ7v8/x+u/XeAwAAAEA900Y9AAAAAABTQ/gBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQD2aK21Wa21Z456DgCA3ZHwAwDs6X4lybdaa3/UWvv3T7a4tXZRa+3gf+P+V7XW/nLi65e01m7dkSFaa4tba0dPfH1Sa+3FE1/PaK1N36FnAgAwZMIPALBH671/JckvJVmb5JIdeMjfJfnv27ujtdaSbEiyfuKm9UnWt9amtdb+rrV2W2vtr1tr/9Ja+49bPe7ZSf44yX4TNx2b5Jcn4s/tSU6bxFMDANhpM0Y9AADAZEzsrvlwxoNPS/JYkldvZ93bk7w3yfd/5vbbJ758VpKLe+/vT/LcJP8rybNaa3+dZN8kz0ny7oxHoJN67/e11r6Z8UCU1tpBSf4yyaO99z9vrc1NcmCS9yRZleS3e+83DfO5AwDsKDt+AIA9Uu/9+t77kb33VyQ5NckLeu+bk6S1dnhr7bkTS9cn+dPe+8Ikb05yV5L/3HtfOHHbJ5Jsmjjmt5P8WpJvJ1me5DNJ7uy9fyBJT7KotXZ8kqcl6a21+UluTPLJiZ97asYj0Lwkf9h7P7b3flNr7ddba/9hSl8QAIDtsOMHAKhi7sRum8eS/GmS7yQ5IcmVSa6eWPPbSVb23vtWj7tsO8eakeSpSZ6y1W2bM74D6KmZ+OPZxO6f1yeZnuR3eu+fTfLZ1toHkpzeWvuliftOTPKqoTxLAIABtG1/7wEA2P211u5M8kjGd+G8KMlYxq+lc1GSI5PckeS8jO/kuSPJoxmPNUck+X+ZOE0r4yHn0SRzkvxm7/3rrbWFSf4q46dp7Zvk4d77WGvtriSv3+pUrxN67/dNzHNgktN67x+Z+H5GkuflX//I9oPe+w+n5tUAAHhiu2zHz8QvRFf03l/5BPcfmeRDGf/F68re+4W7ajYAYM/Se39hkkxcPPlPkqxJ8rdJjklyee/9f2y1/IiJtR+duO8PJ74/Psk5vfejt/Mjbu69n9BaOyLJRydum53k0621x5Ic9jPrX53kd1trb/2Z238hyR299xMn90wBAHbOLgk/rbVnJLk04381eyIXJTklyeokX22tXdl7/96umA8A2GO9K+PX4UnGd/e8K8mHW2sX9t4ffnxRa+2QJP81yedba29M8tUkf5Dk7VsfrLV2ZpJfTzKttXZjxk/Telpr7T1J9k/ygozvFro921qX5K9676e01l6ZZH3v/WuttV9L8rohPl8AgIHsqos7b0pycsa3ZKe1dmBr7S9ba7e01pZOrPmF3vs/TJxzvybjF00EANiuiUjzoiQXP35b7/2aJFckuWHriyn33r+f5ICMR6JTk/wo2/mDVO/9kiTvSPI3vfexjF+o+awk1yT5+977Y733jdsZZ3r+9SPg35fkmRN/+EqSfXbiaQIA7JRdsuOn9/548Hn8pqVJVvTe/6S19rXW2iUZ3+VzVpJ/SjI/4+ffAwBso7X21IyfHn5ikqN774+11rbEld77Ba21R5J8s7X2mt77V1tr+yV5RZKTkvxykjdm/NStj7XW1if5vd77lydOTf90kt+YONzlSVYk+WGS/73VGNMyfn2hx3/m/2mtXdVa+4OJ2/824xeXvirJ7w//VQAA2DGj+jj3X0rymxNbqPdNcnCS/5bknoz/Ve2DP/NpGwAAj3s0yb1JfqX3fndr7e1Jbkty6+MLeu//M8mRE9HnI0m+l/FTva5K8vze+1W998snPs79k0ne3VqbmeSgJL/fe79t4jh/n+R3Mv67yqeSpLV2Ycaj0QOttWmttc9MXGz6WxmPPq+dOF39OUnuTHJ1a23raAQAsMvs0k/1aq3dOPGpGB9N8n977zdMXATxht77P7bWnp3xv6q9XPgBAHbExClVT+29/8MT3L9Pkg0787tFa21m733DxNf7Jln7+PEmLjC9IeMfE795O4+dk+Q5vfdvTfbnAwBM1qjCz0EZ30b97zL+F7hf671vbK1dmuRTvfebd9lQAAAAAEXt0vADAAAAwK4zqmv8AAAAADDFpvxTvfbff/8+f/78qf4xAAAAAHuNO+6446He+wFPtm7Kw8/8+fNz++23T/WPAQAAANhrtNbu35F1TvUCAAAAKEr4AQAAAChK+AEAAAAoasqv8QMAAADsHTZs2JDVq1fnpz/96ahHKWP27NmZN29eZs6cOanHCz8AAADAUKxevTr77bdf5s+fn9baqMfZ4/Xes2bNmqxevTqHHXbYpI7hVC8AAABgKH76059m7ty5os+QtNYyd+7cndpBJfwAAAAAQyP6DNfOvp7CDwAAAEBRwg8AAADADrj22mtz2223PeH9Gzdu3PJ17/0J12196taGDRuyYcOG4Qy4HS7uDAAAAEyJ+UuuHurx7lt+3JOu2bx5czZs2JBZs2Zl06ZNeelLX5q/+Iu/yEEHHbTNuo0bN+Z1r3tdrr322i23vexlL8stt9yy3eP+8z//c84999wcfPDB+bM/+7PMnj3759acddZZOeWUUzI2NpYrrrgiN910Uy666KKfW3fCCSdk6dKlOfTQQ3PNNdfk5ptvzgUXXJBNmzbl0EMPzYwZw8s1dvwAAAAAZVx77bU5+eSTs2nTprz//e/PunXr8ta3vjX7779/VqxYkWQ8Dk2fPj0bNmzI+vXrc+655+ZXf/VXc/fdd2dsbCwnnXTSNsdct25dTjvttCxdujRnn3123vjGN+bHP/7xNmvWrl2bb3zjG3nVq16VDRs25BOf+EQeeuih3HDDDdusu/feezNr1qysW7cul19+ea677ro88sgjueKKK3L55ZfnscceG+rrYccPAAAAUMZrXvOa3HnnnXnve9+bSy+9NBdddFE2b96c888/P3Pnzs23v/3t3HPPPbn00ktz99135+yzz87HP/7xTJ8+PWNjY7nxxhuzfv36Lcf77ne/mzPOOCNvetObcsoppyQZP1Vr4cKFOeecc3LqqafmGc94Rj72sY/l8MMPz7Rp03L22Wfnt37rt/L6178+J554Yh588MG8+c1vTpKcf/75WbBgQRYvXpwPfOADWb16daZNm5aHH34473nPe7LffvsN9fUQfgAAAIBSlixZku9+97t5wxvekDVr1uS8887LRz7ykaxcuTLXXHNNPvShD+UNb3hDxsbGcv755+eYY47JtGnTsnLlyixevDhJcvrpp+fAAw/MGWeckRNPPDFXXnllrrzyyi0/44ILLsiVV16Zgw46KC94wQvy2c9+Ni984Qtz+umnZ/78+RkbG8usWbOyZMmSXHzxxdm4cWNmzpyZlStX5rDDDsu0adPy6KOP5rLLLkuSXH311T+3i2gYhB8AAACglJUrV+b666/P5z//+cyZMyff//738+EPfzgPP/xwHnzwwcybNy+vfe1r861vfSuf+cxncs0112y5rs7ixYtz7bXXZvPmzWmtZeXKlbnuuuty6KGH5txzz00yHpYOPvjgXHHFFUmSr33ta1m+fHlWrFiR5cuX5/rrr89VV12Vt73tbVmyZEluueWW9N6zatWqfPSjH82NN96YJHnsscfyne98J0nyox/9aEpeC+EHAAAAKOXCCy/MmWeembPOOiv77LNPxsbG8sUvfjG33nprvvSlL6W1lnPOOSeHH354lixZkqOOOiqzZs1Kktx5551ZtGhRzj333Bx33HGZO3dupk+fvuXYa9euzZo1a7a5APNLXvKSPPTQQ1mxYkWe9axnZe3atXn2s5+dJHnKU56SJGmt5fDDD8/atWu3PO4HP/hBPvWpTyVJHnjggRxzzDFDfy2EHwAAAKCM733ve7n//vvzohe9KMccc8yW06uOPfbYTJs2LSeddFLe9ra35eyzz87Y2FjmzJmT0047LQcffHCOP/74LF68ONddd90THv+MM87IvvvumyOOOCKPPPJInva0p213hpe97GVPOuv++++fE044IUny9a9/ffJP+t8g/AAAAABTYkc+fn3YPve5z+Wd73xn5syZk6985StJsmXHz9Yfwb5p06a01pIkxx57bJYuXZrjjz8+mzdv/rljttbyk5/8ZMvxk+S2227L0qVLt0Sixx/3wx/+MDfddFPe9773bXe+3ns2b96cTZs25elPf3pe8YpXJMmW42/atGmbHUY7S/gBAAAAynj3u9+9zfdLly7Nvffem5kzZ265bcOGDXn5y1+et7zlLUmSefPm5bLLLss73/nO9N5/7pgvfvGLc8kll2yJNEmyzz775Pzzz9/y/bp167Jx48acd955+eAHP5hp06YlSR555JFtjrVu3bo89NBDOfbYY3PAAQdk2bJlW+677bbbsnHjxi2fHjYMbXtPaJgWLlzYb7/99in9GQAAAMDorVq1KgsWLBj1GNv4xje+kXnz5uWZz3zmqEeZtO29rq21O3rvC5/ssXb8AAAAAEPTe99yCtXu4Mgjjxz1CDtlZzfsTBvSHAAAAMBebvbs2VmzZs1OxwrG9d6zZs2aba5NNCg7fgAAAIChmDdvXlavXp0HH3xw1KOUMXv27MybN2/Sjxd+AAAAgKGYOXNmDjvssFGPwVac6gUAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFDUjFEPAAAAALA3WfW8BTu8dsE9q3bqZ9nxAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFDUpMNPa+3A1tqdwxwGAAAAgOHZmR0/H0kyZ1iDAAAAADBckwo/rbVFSR5N8sBwxwEAAABgWAYOP621fZK8J8mSf2PNma2121trtz/44IM7Mx8AAAAAkzSZHT9Lkny89/6TJ1rQe7+k976w977wgAMOmPx0AAAAAEzaZMLP4iTvaK3dmOSI1tqnhjsSAAAAAMMwY9AH9N5f9fjXrbUbe++/MdyRAAAAABiGnflUr/Tex4Y0BwAAAABDtlPhBwAAAIDdl/ADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUNSMUQ8AAAAAsLt5/qXP3+G1d51+1xROsnPs+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChqxqgHAAAAABjYsqcPuP7hqZljN2fHDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRMybzoNba05N8Lsn0JI8mObn3vn6YgwEAAACwcya74+fUJH/Ye391kgeSvHZ4IwEAAAAwDJPa8dN7//hW3x6Q5Edb399aOzPJmUlyyCGHTHo4AAAAACZvp67x01p7aZJn9N5v3fr23vslvfeFvfeFBxxwwE4NCAAAAMDkTGrHT5K01n4hyUVJ/svwxgEAAABgWCa146e1tk+Sy5Ms7b3fP9yRAAAAABiGyZ7q9etJjkzyu621G1trJw9xJgAAAACGYLIXd/5Ekk8MeRYAAAAAhminLu4MAAAAwO5L+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChqxqgHAAAAAGqav+Tqgdbft/y4KZpk72XHDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRLu4MAAAAe7FBLsDs4st7Hjt+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACK8qleAAAAsJs76IZv7vDaB446YgonYU9jxw8AAABAUXb8AAAAwE66/su/OND6oxfdO0WTwLbs+AEAAAAoSvgBAAAAKEr4AQAAACjKNX4AAADYKyxbtmxK18PuyI4fAAAAgKKEHwAAAICihB8AAACAolzjBwAAgN3G6iU37/DaectfOYWTQA3CDwAAAAO58OTjd3jtu1Z8YQonAZ6MU70AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAipox6gEAAAAYrovf/uWB1r/jk4umaBJg1Oz4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAACjKxZ0BAABGYNXzFgy0fsE9q6ZoEqAyO34AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKEn4AAAAAihJ+AAAAAIoSfgAAAACKmjHqAQAAAHZXz7/0+Tu89q7T75rCSQAmx44fAAAAgKLs+AEAAPZsy54+wNqHp24OgN3QpHf8tNY+3Vr7m9ba7w1zIAAAAACGY1I7flprb0oyvff+0tbaZ1prz+29//2QZwMAAAqYv+Tqgdbft/y4KZoEYO/Teu+DP6i1P0rypd77F1trpySZ03v/463uPzPJmUlyyCGHvOj+++//uWNM6X/8B9nqmQy83XMqL/C26nkLdnjtgntWDXTsi9/+5YHWv+OTi3Z47YUnHz/Qsd+14gsDrV+95OYdXjtv+SsHOvayZcumZG2SXP/lXxxo/dGL7t3htQfd8M2Bjv3AUUcMtH6Q9+igv5xN5bGn8v0/yHs/2XPf/4O895Opff8P8t5P9tz3/yDv/WRq3/9T/T9nu837fwr/7U8Ge/8P8t5P9tz3/1T+258M9v4f9P28p77/B/23H4A9S2vtjt77widbN9lr/Oyb5B8nvv6nJEdufWfv/ZIklyTJwoULBy9LAACwhxo05gxCzAFgUJMNP/+SZM7E10+NTwcDAGCIBt3BN4hBd/AAwJ5ssuHnjiSvSHJrkv+U5O+GNhEAAEMz6Olbgxj09C0AYNebbPj58yQ3t9YOTvK6JL8yvJEAAHYvg16zaxCDXrMHAGAQkwo/vfdHWmtjSY5J8qHe+2BXSAQAGLYBL9gMALA3mOyOn/Tef5zkT4c4CwAAAABDNOnwAwAwqIE/oh0AgJ0i/AAAWwgzAAC1+Bh2AAAAgKKEHwAAAICihB8AAACAolzjBwD2MA8cdcSoRwAAYA9hxw8AAABAUXb8AMAUOHrRvaMeAQAA7PgBAAAAqEr4AQAAAChK+AEAAAAoSvgBAAAAKMrFnQHYay1btmzUIwAAwJSy4wcAAACgKOEHAAAAoCjhBwAAAKAo4QcAAACgKOEHAAAAoCif6gXAbmv9ZuQeAAAcbklEQVTe8leOegQAANij2fEDAAAAUJTwAwAAAFCU8AMAAABQlPADAAAAUJTwAwAAAFCUT/UCYKe8a8UXRj0CAADwBOz4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoasaoBwBg6r3jk4tGPQIAADACdvwAAAAAFGXHD8BuYsE9q0Y9AgAAUIwdPwAAAABF2fEDsIPuOv2uUY8AAAAwEOEHqGXZw6OeAAAAYLch/AC73H3Ljxv1CAAAAHsF1/gBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChqxqgHAHZP9y0/btQjAAAAsJPs+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoasaoBwAm54Gjjhj1CAAAAOzm7PgBAAAAKEr4AQAAACjKqV4whY5edO+oRwAAAGAvZscPAAAAQFF2/LDXW7Zs2ahHAAAAgClhxw8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUTNGPQDsiHnLXznqEQAAAGCPY8cPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUcIPAAAAQFHCDwAAAEBRwg8AAABAUTNGPQA1vGvFF0Y9AgAAAPAz7PgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKEr4AQAAAChK+AEAAAAoSvgBAAAAKGrGqAdg13nHJxeNegQAAABgF7LjBwAAAKAo4QcAAACgKOEHAAAAoCjhBwAAAKAo4QcAAACgKOEHAAAAoCjhBwAAAKAo4QcAAACgKOEHAAAAoCjhBwAAAKCoGaMegG0tuGfVqEcAAAAAirDjBwAAAKAoO34m4a7T7xr1CAAAAABPyo4fAAAAgKKEHwAAAICiap7qtezhUU8AAAAAMHJ2/AAAAAAUJfwAAAAAFCX8AAAAABQl/AAAAAAUJfwAAAAAFCX8AAAAABQl/AAAAAAUJfwAAAAAFCX8AAAAABQl/AAAAAAUJfwAAAAAFCX8AAAAABQl/PD/27v3aOvv+U7g72+eiFtdGhExBlNhrOkFqyjikiCE6czUbWhpS9HQagdrOtSypkXdOp3pUCLFIoYxEswMHcwY0ySIxjXjEkJUEYqimCgxTH3mj+8+eXZOz0ny+P1++zzP1+u11lnPPvuc8/l9n72/v9v79/19NwAAADAowQ8AAADAoAQ/AAAAAIMS/AAAAAAMSvADAAAAMCjBDwAAAMCgBD8AAAAAgxL8AAAAAAxK8AMAAAAwKMEPAAAAwKAEPwAAAACDEvwAAAAADErwAwAAADAowQ8AAADAoAQ/AAAAAIMS/AAAAAAMSvADAAAAMCjBDwAAAMCgBD8AAAAAgxL8AAAAAAxK8AMAAAAwKMEPAAAAwKAEPwAAAACDEvwAAAAADErwAwAAADAowQ8AAADAoAQ/AAAAAIMS/AAAAAAMSvADAAAAMCjBDwAAAMCgBD8AAAAAgxL8AAAAAAxK8AMAAAAwKMEPAAAAwKAEPwAAAACDEvwAAAAADErwAwAAADCoww/kl1tr10lyepJ9Sb6V5CFV9d0lGgYAAADANAc64udhSf6wqu6d5EtJ7jN/kwAAAACYwwGN+KmqF619e/0kX563OQAAAADM5XKDn9bai5Pccu2pM6vqGa21OyX50ap69y5/d3KSk5PkJje5yVxtBQAAAOAAXG7wU1WP2f5ca+3IJC9I8sDL+buXJHlJktzudreriW0EAAAA4AdwQHP8tNaOSPK6JE+pqs8u0yQAAAAA5nCgkzs/KslPJ3lqa+3s1tpDFmgTAAAAADM40MmdT01y6kJtAQAAAGBGBzriBwAAAIBDhOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQR2+Vwv+zHN/dq8WDQAAAPBDwYgfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGJTgBwAAAGBQgh8AAACAQQl+AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABiX4AQAAABiU4AcAAABgUIIfAAAAgEEJfgAAAAAGJfgBAAAAGFSrqmUX0NpXknz2AP7kqCRfXag5h2rtpeurvfn6am++vtqbr6/25uurvfn6am++vtqbr6/25uurvfn6am++vtrT69+0qq5/Rb+0ePBzoFpr76+q26m9ufpqb76+2puvr/bm66u9+fpqb76+2puvr/bm66u9+fpqb76+2puvr/bm6rvVCwAAAGBQgh8AAACAQR2Mwc9L1N54fbU3X1/tzddXe/P11d58fbU3X1/tzddXe/P11d58fbU3X1/tzddXe0P1D7o5fgAAAACYx8E44gcAAACAGQh+AAAAAAYl+AEAAAAY1OF73YAltdaOSfIvknw7yfOr6psz1r5GkpOTfLKq3txa+63Vck6rqkvmWg6MqrX28iT/I8nbqurrM9c+bttTleRLVfXpOZezw3J/vapetOQyDlattYdue+pvk1xUVefuRXv44dVaa0nuneRbSc5N8ttJrpXklKr63F62jYNba+1GSe6T5KSqevBetweAK6+19nNV9cYF6v5WklOr6ltz117Vf/lOTyepqnrkbMvZ68mdW2u3THJJVV3UWntY+sHZq+cIaVprb0vyiiQ/muQOVfVLU2uu1f7PSd6W5K1V9enW2u2THJ/kLlV1v4m1N3by6CBnea2139ntZ1X1jBnq3y/JV6rqXat16OtV9ZapdVe1F+uLrbV/muSeSe6efoL2P9ODoPfUxA1Ta+20HZ6+WZLzquqJU2pfwXLfW1U/M+HvFwurV/UXC6xba7+7w9M/lr7T+pUptS9nmbP0z0N1m9ta25fkxCTfraqzVs+1JA+sqtdPbuyCdggKt8LZs2ao/Zok30hyVJIbJnl/kq8nObGq7jpD/dtW1QdWr/UvJrlakldV1Xcm1v3l3X5WVa+cUntVf7EDyyX3c0v289baEUnulr5Onpjkpkn+KMlZVXX2lNqr+oudLCz8fi75mh+e5J8nOSvJA5Jcd+tnVfXsKbXXlvGT6e/rdZN8LcmZVXXhDHUXa/vSx4pLWjJsX3hfseQAgcXavaq/kaBgbht4Xc6sqnvMUWtb3d9M8stJ/luSP6qqb8xc//Qkt0ryvSQfSvKBJOcl+WxVXTTbcvYy+GmtPS/JLZNcJ8nn0kcgXZzkmKq67wz1315Vx68en11VJ0ytuVb7XVV15yv7/AHWvrTTttZeWFW/MaXettqLHuSslmE01JrW2ruT/ESSi9JPQM5Lcn6S71XVOybWPi3JXyU5vao+2Fr7uST3SnKtqnr4tJYv2xe3LedGSZ6c5LFJvllV11toOZPXzyuoPzX4WSysXtVfLLC+nGWeVVV3X6j2pNd7rc4huc1trZ2RfqD9I0m+lORTSR6d5E+r6glTai9tl6DwZkmuWlU/P7H2+vt5QVX9o9Xjc6rqLhNrvzLJd6rq5NUxzNHp2/PbV9X9J9Z+6tq3j0xy6YF9VT1rSu1V/cUOLLe9n5Ue6B+f5OypB+FL9vPW2sVJrprklCTPSvL6ObdXS54sLPx+Lvmavz59nXlh+uvytCS3TnKvqrrXlNqr+o9O8rtJ3pzkr5Mcmb79fVJVvW5i7cXavuQ6tLaMRcLlJcP2hfcVSw4QWKzdq/qLBwVLXBTbwOvy7SSf3/50eiD2DyfWPizJ05M8MckX5qq7bRlHJnlIkkckuX2ST2wdw8xhr2/1uk1VnbC6svDnSW5eVX/bWpvr1oDrr5LFluTo9ZSxqv7TxNp/2lo7M8lb0q8m/Ej6Cff7J9bd7sdnrvfV7D/IuWf6Qc5OK+EUr0o/ufzY6vu3p++8XpNkkZPLqVprn0zf0bZtP5q8QlfVHVdXQ26efuL3iPQDhQ8lucOU2kmOXR9NUX144xtba++cWHcns/bF1tqx6evMiUluk77DemySt85Q++/t8PSxSa4ytfaq/vYrFknvO0dOLH1EVb16tYwHTay1k2Oq6o+3vqmq9yV5X2tt0gnrTlprd0ty5/TQ91ByKG1zb1xVx622L59O8qIkd53j5HLJbeKqyNN3We7bp9ZOct3W2p3S237J6vFhSa4+Q+0bV9XdW2s3T3KPJLeuqlodD0yyHu601k6cI+zZVv/nV7XXDyz/fZJPJJl0YFlVT1+FnL+Y5DFJPp7kp6vqg1PqrizWz9OD2HsnOSnJOUmOaq09IX2EyIenFq+qF7TWTkk/Wfh8a222k4Ul388s+5rfoKoelCSttVOq6q1J3tr66OU5nJy+Xn5t64nW2nXTj9cnBT9ZsO07rEMXZL51aMuN1x5fJlye6Jiq+oXk0rD9CavHk4O8hfcVix1zLdzupdf/LQ9KX/dnuyh2Oa/LpAvha96zxMXG1tpJSR6f5CtJfqaqPnYFf3Kg9U9PPzf8bvr54WuSPCnJZ+Zczl4HP0e01m6YfkD2xfRw5rAk35+p/hlJbrHD48nDnKrqd1YHkyeln1BenOSlVfUnU2snOWYtsNp6vLXcqYHVogc5K4udXK6djFzm6Uw8iKqqW1zxb/1gWmvPTV+ZD09PiLdW5g/MUP6C1aifN+eyAeRcwwKPaa39Qvb3xa3Hc/TFVyf570n+XfqGeq71Pklem2Rf+gb0+6uvr2b6Qd+W3frLqybWXTKsTjYXWCf9qt+X0ofFT7JL0JZMD9q2LL3NvVf6Fed3pm9zH58+4mfqNvdqawHH19K36T/eWktV/dmUwktuE5Ok/d15uJJ+1W/fDOU/lH7yt/3xHPu4r69Gsd4/ye8lueZcwem21+Taa+/t5PdzVf+M9CvEsx9YttaelT4i5Pwkv5++7l+jtXbcDG1fsp9/Pf348Iwkaa39VPrx0b9NP1aapLV2n/RbSWY/WVj4ROGqa6/5X2fG1zzJea21NyQ5O8nFq+3hSUn+98S6W66S5Jar0GrdVWeovVjbW2vPTPKrWWYdSrJouHydpcL2hfcV11/b3896zLVLu4/NPO3eWFCwZpaLYpfzfm5fX39QS93mfr8kv15Vn1mo/iVJ3r32/a1XX5Ue0s5ir2/1Oif7T84q/eRsX5LrVdVP7lnD9lhr7YNJ/utOP9stKZ2wrK2DnHtX1eSDnFXNZyS5S/7uyeVfVNXj51jG3Nru91ZXVf3exNrnpIc+6yHEviRHVtVPTaz9yCQ3SL86dHR6APms9PvyXzyl9qr+H6SfNF2Y5E1J/lX237b35Kn1l9Jae22Sv8n+Yep/keRROchvgVkbAru1Yb5xemBwbs0wB1dr7dfSDxDund5vLk7yrvSru6dMrb+UDbwuT0ty2/QAbF/6Fderps/b8tsTa69fUW1Jrp2+zf2zqdvc1torklwvPdTcl+Rh6f39nTMMgT8syYPThxpfO72vvCd9xNLkkLa19pX0WyVa9r+vf5Xkj6vqs1PrL6W1du0kj0vykap60yoEenKSW1XVFyfWPjP9oP2wJCesnj47yb45bkFY9Zej0kOI9f7yjq2r9QvUnqMv7jRnW5L8bFUdPaX20lprL00fufGJmn9etbemhzIPSfKG9HU0mWeOn+9l/3rZkvy/JO9I8pdTa6/q3zO9jx+V5Ij0/dJdq2qOCwXrbU/6Bw3M0vbW2uPSR7OdkN72i5O8a46Lvq21L6fPj/O1bT+arZ9vO+l+QZLf3PpmSri01hcfnOSN2d8XUxPn+GutvS79mOW76cehD0/f5x1fVRdMrP3i9HY/Kcnzc9l1aOrcZK9MP/f5aPrghocm+YMkb66qyaPyV/183azr6GoZH0vyzPRtwFNXj5P84MHY2va81v79Z+kXw8w1u7C9HvHzhex8cva/9rJRB4GvzR3wbGnbZjuvqo8k+Uj61a1ZLDwaainrSfNl7q1Ov6o7xW79fPKtAemjKpLkpauaL0s/SZsr0T02/aRma06Yt6Qf8Cw2T85MblRVd15omPqSnpM+H8x9028Lumn6wdkcfSXp7+WXkvzHJM/YOoFfnXAetMFPln9dbpbki6uh9s9Pv+pyfnroMdU1sv8+/A+mH5g9L8kc4cZh6e0+edXuMzJfu1+WPmnxOeknqtdM8sD092COybrP3zo4nWsI+Yaclj4R/fmr79+evv84NdNvZX5Y+lXVE9L7x3Hp88PM9UlkhyX5wkL9ZbHau504ttbeN7X2Blwvfa6cj66+n/PW933po33PTR9NNOck+s/c4bkfywxX5Ve3M7X0beOd0rfnn898+6DF2p4+ufU90kfPvnDmC2DfTnJM+lQJL1rbP88y6e3Kr649/vDa95VkyqiiJfvivlz2OPTU9HXoOZm+Dh2bvk9+Ynq7/+XEeuuOSA9kj0rvfy9IH9Xx7CSTP2Qgy/bzLUvcOfOY9PfvPlnmeI7LU1V79pWekie9k34mPXG97l626WD4St/4X7jt65NJLpyh9pl7/f87WL/SN9KPTL+q/Yr0OajmqLuRfr7Ee7vV9h2eP2ev368raPd56QeUx60eH7f1tddtu4J2X5zk/yb5w/QThlnf0/RPIrnKqg+emz7S76DfLmzidVn9e/P0g+Gt0bCzLSf9trRfW21fvp/kgpnb/aE5250+CmSn52dZ99fbeLD3v23t3m2buOPzB1j7q+lXtc9M/1Sc2ya52oxtX7K/LFb7cpb53r3uD3vcX87e6fHC/5+zZqix6PZ84bYvtt1arfeH3P551cazd3o8U+1Dch3a1lc+tvZ40ePnOfr5wu3bk/XfV//a6xE/V1/qvu1D3CITU63csbV2YS47vH72WckPNQvPT7BYP982bPc669/PtA6ducucMOfNUHtJ2+f4mOuq1tIWn4Orqr6X5N+01v5Dkme31n4j/TbBg9nSr8tO87Y8YIa6S9+Hv97uZ2bGdif56mp+sndk/6f7nJDkyzPVX3JepSUtOU/WLdLDnuPTR1Y9LcmXW2ufmumYYMn+sljtXeb4mmMy/U3YbR86R385ui07J9yl2ryT9W9irslLzdz2Jbdb7RDdPyfL9sVDdR1a/5CB78w579FOZu7nS9ro+s9l7fUcP7vdt1010/2Jh6LW2uNqofk22oIfrby2jEUmYF7Skn3xUK29toyt2/YunROmDu7b9oYx9xxcrbV/XFVv2fbcbZM8pqpO3uXPDjoLvC7XSPJL6ffGv6n1T2x6dJLn1/R5W5Zc/5ds9zXT53+4Q5JrZf8cPy+sqm9Nqb2qv9snm1VNnFthaUttE1trH0+fI+ei9GDws1v/VtUnZqi/ZH9Zsvaun4JXC90WP6cF+8vG1qHW2kPSb806o6pmPbGce3u+Q/3Z2r7ka76J/fNSx+dL98VDcR26nH1/at5b4baWN/s6uonzuaXXfy5rT4MfNq+19q/T5224JP2A7Jt73CQAAABgIYftdQPYuOOTfCzJN9InvAUAAAAGtddz/LB5h1fVq5OktfagvW4MAAAAsBzBzw+fjU0GCAAAAOwtwc8PnzPSPzlk+2OTPQEAAMBgTO4MAAAAMCiTOwMAAAAMSvADAAAAMCjBDwBAktba867E79ymtXabTbQHAGAO5vgBALiSWmuPSJKqesXetgQA4MoR/AAAQ2itPTXJR6vqDa21pyT5fJKHJblmkj+vql9Z/d7ZSd6X5FZVddLa359dVSesHl8jySuTHJ3kI1X1uNbac5Lcf/Xrf1lV92ytPT3JBVV1emvtaUk+XlWnb+C/CwBwpbjVCwAYxeuS3Hf1+G5JPpzkBUlOTPIPWms3WP3sjknOXQ99dnBykvOr6m5Jbthau1VVPSXJc5M8t6ruufq9VyZ56OrxSUneONv/BgBgBoIfAGAIVXVhkr/fWrt2km8k+T9JHp3k1UmOTHL11a+eX1X/5QrK3TLJ/Vejg26W5Ea7LPNTSa7VWjthVfeSqf8PAIA5Hb7XDQAAmNF7kzwhyZ8keVSS1yd5bZK3r/3O31yJOp9I8t6qOq219k+SXLR6/pIk10uS1lqrfs/86UlenuThs/wPAABmZMQPADCS16UHP29K8rYkT0ly5upnO47a2cVLk9y3tfaOJI9N8rnV829L8oDW2ruS3HX13OuTVJJzpjUdAGB+JncGAPgBtdZ+IslpSV5cVS/b6/YAAGwn+AEAAAAYlFu9AAAAAAYl+AEAAAAYlOAHAAAAYFCCHwAAAIBBCX4AAAAABvX/AZHyB+8QcC2KAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1440x1152 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pymongo\n",
    "import pandas as pd\n",
    "import matplotlib as plt\n",
    "from pandas import Series,DataFrame\n",
    "pd.set_option('display.width', None)  # 设置字符显示宽度\n",
    "pd.set_option('display.max_rows', None)  # 设置显示最大行\n",
    "pd.set_option('display.max_columns', None)  # 设置显示最大行\n",
    "from locale import *\n",
    "import re\n",
    "\n",
    "setlocale(LC_NUMERIC, 'English_US')\n",
    "\n",
    "atof('123,456')    # 123456.0\n",
    "\n",
    "#连接数据库\n",
    "client = pymongo.MongoClient('localhost',27017)\n",
    "futures = client.futures\n",
    "\n",
    "\n",
    "market = futures.market\n",
    "unit = futures.unit\n",
    "position = futures.position\n",
    "#加载数据\n",
    "market = DataFrame(list(market.find()))\n",
    "unit = DataFrame(list(unit.find()))\n",
    "position = DataFrame(list(position.find()))\n",
    "\n",
    "\n",
    "# #类型转换\n",
    "# market['set_close'] = market['set_close'].astype(float)\n",
    "# unit['unit'] = unit['unit'].astype(float)\n",
    "\n",
    "#大写字母\n",
    "position['variety']=position['variety'].str.upper()\n",
    "\n",
    "#删除/选取某行含有特殊数值的列\n",
    "position=position.set_index('名次')\n",
    "\n",
    "#选择需要显示的字段\n",
    "data1=market[['date','variety','set_close']]\n",
    "\n",
    "data2=unit[[ 'variety','unit']]\n",
    "position=position[['date','variety','symbol','持买仓量期货公司','持买仓量', '持买仓量增减','持卖仓量期货公司','持卖仓量', '持卖仓量增减']]\n",
    "# print(position.head())\n",
    "\n",
    "#查询会员\n",
    "members='永安期货'\n",
    "data3=position[(position['持买仓量期货公司'] == members)]\n",
    "#汇总合约\n",
    "data3=data3[['date','variety','持买仓量期货公司','持买仓量']]\n",
    "data3=data3.groupby(['date','variety','持买仓量期货公司'])[['持买仓量']].sum()\n",
    "data4=position[(position['持卖仓量期货公司'] == members)]\n",
    "# print(data4.head())\n",
    "data4=data4[['date','variety','持卖仓量期货公司','持卖仓量']]\n",
    "data4=data4.groupby(['date','variety','持卖仓量期货公司'])[['持卖仓量']].sum()\n",
    "print(data3)\n",
    "print(data4)\n",
    "#并集\n",
    "data5=pd.merge(data3,data4, on=['date','variety'],how='outer')\n",
    "data5['会员简称']=data5.apply(lambda x: members,axis=1)\n",
    "#nan缺失值填充fillna()为0\n",
    "data5=data5.fillna(0)\n",
    "data5['净持仓']=data5.apply(lambda x: x['持买仓量']-x['持卖仓量'],axis=1)\n",
    "#选择需要显示的字段\n",
    "data5=data5[['会员简称','持买仓量','持卖仓量','净持仓']]\n",
    "data5=data5.reset_index(['variety','date'])\n",
    "print(data5)\n",
    "\n",
    "#合约价值\n",
    "contractValue=pd.merge(data1,data2,how='left',sort=False).drop_duplicates()\n",
    "contractValue['contractValue'] = contractValue.apply(lambda x: x['set_close']*x['unit'],axis=1)\n",
    "contractValue=contractValue[['date','variety','contractValue']]\n",
    "#值替换replace()\n",
    "contractValue=contractValue.replace(['TA'],'PTA')\n",
    "print(contractValue)\n",
    "# contractValue.set_index(['date','variety'], inplace = True)\n",
    "sz=pd.merge(data5,contractValue,on=['date','variety'],how='left')\n",
    "#净持仓价值\n",
    "sz['净持仓价值']=sz.apply(lambda x: x['净持仓']*x['contractValue'],axis=1)\n",
    "sz=sz[['variety','净持仓价值']]\n",
    "sz=sz.sort_values(by='净持仓价值')\n",
    "print(sz)\n",
    "# sz=sz.set_index('variety')\n",
    "sz.plot.bar(x='variety',y='净持仓价值',figsize=(20,16),title=members)\n",
    "#二行即可搞定画图中文乱码\n",
    "plt.rcParams['font.sans-serif']=['SimHei'] #用来正常显示中文标签\n",
    "plt.rcParams['axes.unicode_minus']=False #用来正常显示负号\n",
    "# print(hb)\n",
    "# hb=hb[['date','variety','closunit']]\n",
    "# data3 = position.merge(hb)\n",
    "# data3['持买仓量']=data3.apply(lambda  x: x['持买仓量']*x['closeunit'],axis=1)\n",
    "# data3['持卖仓量']=data3.apply(lambda  x: x['持卖仓量']*x['closeunit'],axis=1)\n",
    "# print(data3.head())\n",
    "#\n",
    "# df = data3[(data3['持买仓量期货公司'] == '永安期货') & (data3['持卖仓量期货公司'] == '永安期货')]\n",
    "# df['净持仓1']=df.apply(lambda x: x['持买仓量']-x['持卖仓量'],axis=1)\n",
    "# print(df[['date','variety','持买仓量期货公司','持卖仓量期货公司','净持仓1']])\n",
    "# print(data3.groupby(['date','variety'])[['持买仓量','持卖仓量']].sum())\n",
    "# print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180718.dat HTTP Error 403: Forbidden\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD3CAYAAAAUl4NyAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAFXhJREFUeJzt3X2UZVV95vHvMw34hoBAB4GmhRhMRA0ZLMExJpJBIxC1SYZMEGPQCekwAeJLnBFDIiFqxGXU9gXodJSFTjBMJhpF0hGVDL5EydAgKi8LaTFAN2g3GFAQbVp+88c5JZdLVTdd99hdsL+ftWrVPfvue/Y+L3c/+5yqW5WqQpLUnv+wrTsgSdo2DABJapQBIEmNMgAkqVEGgCQ1ygCQpEYZAJLUKANAkhplAEhSo7bb1h3YlN1337323Xffbd0NSXrYuPzyy2+rqoUPpe68DoB9992XVatWbetuSNLDRpIbH2pdbwFJUqMMAElqlAEgSY0yACSpUQaAJDVqkABIck6SdUmumuX5JHlPktVJvprkoCHalSTN3VBXAOcCh2/i+SOA/fuvpcDZA7UrSZqjQQKgqj4HfGcTVZYAH6rOpcAuSfYcom1J0txsrQ+C7Q3cPLK8pi+7dbxikqV0VwksXrx4q3ROkraVnJ4HldVpW+d/tc+7HwJX1YqqmqqqqYULH9KnmSVJc7C1AmAtsM/I8qK+TJK0jWytALgA+J3+t4GeDdxZVQ+6/SNJ2noG+RlAkr8FDgV2T7IGOA3YHqCqlgMrgSOB1cD3gVcO0a4kae4GCYCqeulmni/gxCHakiQNY979EFiStHUYAJLUKANAkhplAEhSowwASWqUASBJjTIAJKlRBoAkNcoAkKRGGQCS1CgDQJIaZQBIUqMMAElqlAEgSY0yACSpUQaAJDXKAJCkRg0SAEkOT3JdktVJTpnh+Z2TfCLJV5JcncR/CSlJ29jEAZBkAXAmcARwAPDSJAeMVTsRuKaqDqT738HvSLLDpG1LkuZuiCuAg4HVVXVDVW0AzgeWjNUp4PFJAuwIfAfYOEDbkqQ5GiIA9gZuHlle05eNeh/wVOAW4GvAq6rqvgHaliTN0db6IfALgSuBvYBfAN6XZKeZKiZZmmRVklXr16/fSt2TpPYMEQBrgX1Glhf1ZaNeCXy0OquBbwI/N9PKqmpFVU1V1dTChQsH6J4kaSZDBMBlwP5J9ut/sHsMcMFYnZuAwwCS7AH8LHDDAG1LkuZou0lXUFUbk5wEXAQsAM6pqquTnNA/vxx4E3Bukq8BAV5fVbdN2rYkae4mDgCAqloJrBwrWz7y+BbgV4doS5I0DD8JLEmNMgAkqVEGgCQ1ygCQpEYZAJLUKANAkhplAEhSowwASWqUASBJjTIAJKlRBoAkNcoAkKRGGQCS1CgDQJIaZQBIUqMMAElqlAEgSY0aJACSHJ7kuiSrk5wyS51Dk1yZ5Ooknx2iXUnS3E38LyGTLADOBF4ArAEuS3JBVV0zUmcX4Czg8Kq6KclPTdquJGkyQ1wBHAysrqobqmoDcD6wZKzOscBHq+omgKpaN0C7kqQJDBEAewM3jyyv6ctGPQV4QpJLklye5HcGaFeSNIGJbwFtQTvPBA4DHgN8KcmlVfX18YpJlgJLARYvXryVuidJ7RniCmAtsM/I8qK+bNQa4KKquruqbgM+Bxw408qqakVVTVXV1MKFCwfoniRpJkMEwGXA/kn2S7IDcAxwwVidjwPPTbJdkscChwDXDtC2JGmOJr4FVFUbk5wEXAQsAM6pqquTnNA/v7yqrk3ySeCrwH3A+6vqqknbliTN3SA/A6iqlcDKsbLlY8tvB94+RHuSpMn5SWBJapQBIEmNMgAkqVEGgCQ1ygCQpEYZAJLUKANAkhplAEhSo7bWH4OTpObl9DxguU6rbdSTjlcAktQoA0CSGmUASFKjDABJapQBIEmNMgAkqVEGgCQ1ygCQpEYZAJLUqEECIMnhSa5LsjrJKZuo96wkG5McPUS7kqS5mzgAkiwAzgSOAA4AXprkgFnqvQ341KRtSpImN8QVwMHA6qq6oao2AOcDS2aodzLwEWDdAG1KkiY0RADsDdw8srymL/uxJHsDvw6cvbmVJVmaZFWSVevXrx+ge5KkmWytHwIvA15fVfdtrmJVraiqqaqaWrhw4VbomiS1aYg/B70W2GdkeVFfNmoKOD8JwO7AkUk2VtXHBmhfkjQHQwTAZcD+SfajG/iPAY4drVBV+00/TnIucKGDvyRtWxMHQFVtTHIScBGwADinqq5OckL//PJJ25AkDW+Q/whWVSuBlWNlMw78VfWKIdqUJE3GTwJLUqMMAElqlAEgSY0yACSpUQaAJDXKAJCkRhkAktQoA0CSGmUASFKjDABJapQBIEmNMgAkqVEGgCQ1ygCQpEYZAJLUKANAkhplAEhSowYJgCSHJ7kuyeokp8zw/MuSfDXJ15J8McmBQ7QrSZq7iQMgyQLgTOAI4ADgpUkOGKv2TeB5VfUM4E3AiknblSRNZogrgIOB1VV1Q1VtAM4HloxWqKovVtW/94uXAosGaFeSNIEhAmBv4OaR5TV92Wx+F/inAdqVJE1gu63ZWJJfoQuA526izlJgKcDixYu3Us8kqT1DXAGsBfYZWV7Ulz1Akp8H3g8sqarbZ1tZVa2oqqmqmlq4cOEA3ZMkzWSIALgM2D/Jfkl2AI4BLhitkGQx8FHg5VX19QHalCRNaOJbQFW1MclJwEXAAuCcqro6yQn988uBNwK7AWclAdhYVVOTti1JmrtBfgZQVSuBlWNly0ceHw8cP0RbkqRh+ElgSWqUASBJjTIAJKlRBoAkNcoAkKRGGQCS1CgDQJIaZQBIUqO26h+Dk6QW5PQ8YLlOq23Uk03zCkCSGmUASFKjDABJapQBIEmNMgAkqVEGgCQ1ygCQpEb5OQBJmqPx3/eH+fs7/zMZ5AogyeFJrkuyOskpMzyfJO/pn/9qkoOGaFeSNHcTXwEkWQCcCbwAWANcluSCqrpmpNoRwP791yHA2f13SZr3Hu4z/dkMcQvoYGB1Vd0AkOR8YAkwGgBLgA9VVQGXJtklyZ5VdesA7UvSIB6pA/1shgiAvYGbR5bX8ODZ/Ux19gYMAGkbmOlv1cw2+M2X8umB+CfZ99akm5RPsILkaODwqjq+X345cEhVnTRS50LgjKr6Qr98MfD6qlo1w/qWAksBFi9e/Mwbb7xxbv3agpNntvKHw4k/3/s+2k9JP3lJLq+qqYdSd4grgLXAPiPLi/qyLa0DQFWtAFYATE1NNTlyzDZgbkn5EOsYslzS/DNEAFwG7J9kP7pB/Rjg2LE6FwAn9T8fOAS48+Fw/9/BUtIj2cQBUFUbk5wEXAQsAM6pqquTnNA/vxxYCRwJrAa+D7xy0nbn3F8HY0kCBvogWFWtpBvkR8uWjzwu4MQh2pIkDcM/BSFJjTIAJKlRBoAkNcoAkKRGGQCS1CgDQJIaZQBIUqMMAElqlAEgSY0yACSpUQaAJDXKAJCkRhkAktQoA0CSGmUASFKjDABJapQBIEmNMgAkqVETBUCSXZN8Osn1/fcnzFBnnyT/N8k1Sa5O8qpJ2pQkDWPSK4BTgIuran/g4n553Ebgj6rqAODZwIlJDpiwXUnShCYNgCXAB/vHHwSOGq9QVbdW1RX94+8B1wJ7T9iuJGlCkwbAHlV1a//4W8Aem6qcZF/gPwL/uok6S5OsSrJq/fr1E3ZPkjSb7TZXIclngCfO8NSpowtVVUlqE+vZEfgI8Oqq+u5s9apqBbACYGpqatb1SZIms9kAqKrnz/Zckm8n2bOqbk2yJ7Bulnrb0w3+51XVR+fcW0nSYCa9BXQBcFz/+Djg4+MVkgT4AHBtVb1zwvYkSQOZNADOAF6Q5Hrg+f0ySfZKsrKv84vAy4H/nOTK/uvICduVJE1os7eANqWqbgcOm6H8FuDI/vEXgEzSjiRpeH4SWJIaZQBIUqMMAElqlAEgSY0yACSpUQaAJDXKAJCkRhkAktQoA0CSGmUASFKjDABJapQBIEmNMgAkqVEGgCQ1ygCQpEYZAJLUKANAkho1UQAk2TXJp5Nc339/wibqLkjy5SQXTtKmJGkYk14BnAJcXFX7Axf3y7N5FXDthO1JkgYyaQAsAT7YP/4gcNRMlZIsAn4NeP+E7UmSBjJpAOxRVbf2j78F7DFLvWXA/wTum7A9SdJAtttchSSfAZ44w1Onji5UVSWpGV7/ImBdVV2e5NCH0N5SYCnA4sWLN1ddkjRHmw2Aqnr+bM8l+XaSPavq1iR7AutmqPaLwEuSHAk8Gtgpyd9U1W/P0t4KYAXA1NTUgwJFkjSMSW8BXQAc1z8+Dvj4eIWqekNVLaqqfYFjgH+ebfCXJG09kwbAGcALklwPPL9fJsleSVZO2jlJ0k/OZm8BbUpV3Q4cNkP5LcCRM5RfAlwySZuSpGH4SWBJapQBIEmNMgAkqVEGgCQ1ygCQpEYZAJLUKANAkhplAEhSoyb6INh8Vqf5Z4QkaVO8ApCkRhkAktQoA0CSGmUASFKjDABJapQBIEmNMgAkqVEGgCQ1ygCQpEalav5+YjbJeuDGCVezO3DbPCmfT33Z0vL51JctLZ9PfdnS8vnUly0tn0992dLy+dSXTZXP5ElVtfAh1ayqR/QXsGq+lM+nvtj3h0f5fOqLfZ9/5ZN+eQtIkhplAEhSo1oIgBXzqHw+9WVLy+dTX7a0fD71ZUvL51NftrR8PvVlS8vnU182VT6Ref1DYEnST04LVwCSpBk8Iv8hTJJXAFdW1ZVJPgt8GvgRcCvwNGBH4InA54BnAV8AXgx8EngM8A3gcSN1PwCcCnwJ+GXgT/p1LwOuBBYCU8A9/fJG4LHAU4EAdwIvAL4HPAf4U2AdsB9wH/Dl/vlv9uu4ve/D84AjgLcBTwG+D5wDvLV//VOANwKHAb8FXATc0dc7ALir34Yrquq9Sb4E/DvwKWAJ8AngN/vtn97Ov+v7/fPAR4D/DawFnl5Vxyc5FNgFeBHwe1VVSc4Bfh84ETgc+CxwBfB7wDuq6kvjx2Vk+aXAhX3/Pgx8qqrOneVYvmLs+P0L8Cv98d0P2Knv623AIcB1/T54cv/4jqo6t1/Pi6vqv/THkKp6dV9+VFUd1be9rKpePVNf+uXtx7Z5177qff1+/mTf7/cAN4zU+8P+mH4X+On+eG8A/qWvv6I/vrf327Qj3bl7Id3586tVdWySk/v9cTXweOCWkX31j8BlI+fA16rqnf32fqOv/26683pd3/cfAfcCXwR2qaqPjW379L6/uT8fRvtwXr8vXtN/n+773wBPAo4CvjNyPK4HDgTeBBwPfIvuVx13qqo/HGn3ZODxVfUXjOi348/pzsObquqSkT7eB/wC3XvntTzwfXN6Vd3Rv/5tI33dAHx0bPkg4Gt0Y0H1++XldO/ne+km0Dv2+3N1VX0syZ8By/rt/S26c/NA4MSqumtsP36g79/afvlc4GXAvwE7040hOwI/A/xVVf19ki8Cf1xVlzCAR2QAjPlyVb05yWn98nnAo+gO9ueBBcAPgB9W1bsBkrwPWNXXXQD8p/61jwXuBl7WD4RPA+6uqlNHDmwBe1XVH/fregLdifdq4JeApWP9241uIIfuTbgK2AF4XVUtSXIr3Rv7GX2/fwl4fv/9ef3rR60Hfo5uEPxnYBGwe5Kfpgsg6ELmrn7b7h3bzk/ShcLP0A2ao/VH/RPwwiS3AF+pqnuBZUl2Ac4Gng28BTiSLjhnc89I/9Zvot606eN3cVX9ev+6D9MNBl8GPl1V1yb5I+CH/T44eWTfTLsqyYtmWP+jkkwP+jttqiMzbPNRdOfAbnTnybT7qmq03tP78ufxwIFh2oHAYX35f6UL889W1deTPAe4rd/u3fttfDRdmOw8so7H88BzYNcke9JNSKbrHw/8r35/bUc3eN8ztp5R0/v+98f68APgucC7gLcDJ/R93x54L92AeiP3H4+lfRj9Ad2A+8aq+l6SI4F3TjfW9+nRwHeT7FxVd4705c/69q6qqg+N9XM3uonYQX1/R98365Lc0++TE4Ezququvr03Ty/37++D6Ab5jXTHc2e6SdOXgL+mm3wtAPZk5rH0hyPb+Rjufw+NjyvTy79GN378P2B/uvP5UcDFwKX956KumKGdOWshAJ6R5J10sw+AY+lO2I/0B+doutnCqOkfjPwm3UnwOmC7/k18EfDWfpb1tLHXnUc3s5ke/JcCr6QbBA8ELqcbGB9HN+s6j26G8a/Am/sZxLuAr4z04VN0J+paupPocLoT4njghXQzEuhOtmX9439Mshh4BfAS4LeBs+hOrA1V9VdJnlpVb09yUN/Hp0xvZ78/1vR9OG/kage6cPoh3cxmWb8v3zTDfn9xvy+enuSnqmrdDHWmXdT378+5PwxnM338Pp/kdcBV/eveQDfjKoCqesfIPnhhVf33sfX8A90VSuhme9N+vB9HtnlLTB/T6+lCcibr+3PpLdx/nDcA2/ePM7Idf5dkD+Al/eD/PeB8uv11Ot0M/h66We6PRtZxBXAB958DB/V1nzxSf32/nYvoBt4fAKu5/2p53PS+v5xucJruw3F0V4z3AD870vd7k1zK/VclPz4nk3yTbob+ldl2JN1V6m59X4+lC0/6dd+R5Ea6WfSo6f1/FnA0D37fnN2/dl9G9nNvfPkTdAPzs+gG4h/RXekfRHf3YHp8eDOwV/+a7bn/fNohyav67Tx3ZL2j48pzxpZvoZsYHE13Jf4DuquXa4DfpTtvB/NIDoDpWfo9VfXaflZ/L/Dh/mQ8r5/p7Ud3Cbdzf7AeQ3dwHwf8H7pBbhnw2CThgTPhu4Fv9APRs+iuBq5Mcn2S/0F3ebqB7g2yvq//l3Qn/VvoLvduB94BvDjJk/u+ALwryal0J8DRwG/Q3Xo5je7K5f10b/A/obtq+LEkL6Gbwe9Od+n/xSSvoTvRpj25397d6GZS3+y387L++510wTXt2/06ngScVlUbk6wFFo7NzAD2pbskXtbPOv8bcMbYcbmQ7g2300j/HsXmTR+/ZVX1l0nOoguk4+huu7y8nykdRDcL3J1uQJjJe+nC56G+qUJ3e2FTpo/p6cAxSX4ZuGmWumcCb0gyfbvkmX39lWPld9HdZvwssAfdgPiafua+qKpeBJDk7JE2H0933kyfA3ckuRZYMlL/r+lmwt8GFgN/UFVXJLkSuLwfJD9XVdOzzul9/4qxPnye7qp3XZJdgbf2A/wG+iuhGc7Jdye5gu498qf9le5udBOeaYdW1cn965clSW3+t1am9/8ldAPqK3ng+2a2/b9hhuW1Y324ku4W0j/0++AzdO+V5cC/Jdmb7mrv+/1Y8eiR7XwtXVDAA8eV0eUVdLc1H0cXwD8+14G/p5vAPWMz279Fmv8toP4kP53u5L9707U1lIfbfn+49VfbzsPpXGk+ACSpVf4aqCQ1ygCQpEYZAJLUKANAkhplAEhSowwASWrU/weBjUMRd6kkBwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x95c7f28>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>LR</th>\n",
       "      <td>-0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PB</th>\n",
       "      <td>-0.025729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JD</th>\n",
       "      <td>-0.025646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RB</th>\n",
       "      <td>-0.018274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HC</th>\n",
       "      <td>-0.016274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FG</th>\n",
       "      <td>-0.014746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZN</th>\n",
       "      <td>-0.013752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BB</th>\n",
       "      <td>-0.013647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IC</th>\n",
       "      <td>-0.009400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WR</th>\n",
       "      <td>-0.008608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IF</th>\n",
       "      <td>-0.008585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SM</th>\n",
       "      <td>-0.007368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FB</th>\n",
       "      <td>-0.007134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RM</th>\n",
       "      <td>-0.007100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FU</th>\n",
       "      <td>-0.006768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>V</th>\n",
       "      <td>-0.005462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TA</th>\n",
       "      <td>-0.005022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L</th>\n",
       "      <td>-0.003487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JM</th>\n",
       "      <td>-0.002522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>I</th>\n",
       "      <td>-0.002148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PP</th>\n",
       "      <td>-0.001821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZC</th>\n",
       "      <td>-0.001798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SF</th>\n",
       "      <td>-0.001745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NI</th>\n",
       "      <td>-0.001194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IH</th>\n",
       "      <td>-0.000703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J</th>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T</th>\n",
       "      <td>0.000225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BU</th>\n",
       "      <td>0.000414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TF</th>\n",
       "      <td>0.000423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CU</th>\n",
       "      <td>0.001450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CS</th>\n",
       "      <td>0.001533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M</th>\n",
       "      <td>0.002247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AU</th>\n",
       "      <td>0.002478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SN</th>\n",
       "      <td>0.003630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AG</th>\n",
       "      <td>0.004229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <td>0.005348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P</th>\n",
       "      <td>0.005372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MA</th>\n",
       "      <td>0.005577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CY</th>\n",
       "      <td>0.006095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SR</th>\n",
       "      <td>0.007029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OI</th>\n",
       "      <td>0.007295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>0.007563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y</th>\n",
       "      <td>0.008015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B</th>\n",
       "      <td>0.008585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WH</th>\n",
       "      <td>0.009772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C</th>\n",
       "      <td>0.010607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CF</th>\n",
       "      <td>0.012519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AP</th>\n",
       "      <td>0.024026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RU</th>\n",
       "      <td>0.041807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JR</th>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RI</th>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RS</th>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PM</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ry\n",
       "LR -0.500000\n",
       "PB -0.025729\n",
       "JD -0.025646\n",
       "RB -0.018274\n",
       "HC -0.016274\n",
       "FG -0.014746\n",
       "ZN -0.013752\n",
       "BB -0.013647\n",
       "IC -0.009400\n",
       "WR -0.008608\n",
       "IF -0.008585\n",
       "SM -0.007368\n",
       "FB -0.007134\n",
       "RM -0.007100\n",
       "FU -0.006768\n",
       "V  -0.005462\n",
       "TA -0.005022\n",
       "L  -0.003487\n",
       "JM -0.002522\n",
       "I  -0.002148\n",
       "PP -0.001821\n",
       "ZC -0.001798\n",
       "SF -0.001745\n",
       "NI -0.001194\n",
       "IH -0.000703\n",
       "J   0.000000\n",
       "T   0.000225\n",
       "BU  0.000414\n",
       "TF  0.000423\n",
       "CU  0.001450\n",
       "CS  0.001533\n",
       "M   0.002247\n",
       "AU  0.002478\n",
       "SN  0.003630\n",
       "AG  0.004229\n",
       "AL  0.005348\n",
       "P   0.005372\n",
       "MA  0.005577\n",
       "CY  0.006095\n",
       "SR  0.007029\n",
       "OI  0.007295\n",
       "A   0.007563\n",
       "Y   0.008015\n",
       "B   0.008585\n",
       "WH  0.009772\n",
       "C   0.010607\n",
       "CF  0.012519\n",
       "AP  0.024026\n",
       "RU  0.041807\n",
       "JR  0.100000\n",
       "RI  0.500000\n",
       "RS  1.000000\n",
       "PM       NaN"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import fushare as fushare\n",
    "fushare.get_rollYield_bar(type = 'var', date = '20180718',plot = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Anaconda36\\lib\\site-packages\\pandas\\io\\parsers.py:782: FutureWarning: The 'tupleize_cols' argument has been deprecated and will be removed in a future version. Column tuples will then always be converted to MultiIndex.\n",
      "\n",
      "\n",
      "  self.options, self.engine = self._clean_options(options, engine)\n",
      "D:\\Anaconda36\\lib\\site-packages\\pandas\\core\\indexing.py:362: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  self.obj[key] = _infer_fill_value(value)\n",
      "D:\\Anaconda36\\lib\\site-packages\\pandas\\core\\indexing.py:543: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  self.obj[item] = s\n",
      "D:\\Anaconda36\\lib\\site-packages\\pandas\\core\\frame.py:3140: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  self[k1] = value[k2]\n",
      "D:\\Anaconda36\\lib\\site-packages\\pandas\\core\\frame.py:6211: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=False'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass 'sort=True'.\n",
      "\n",
      "  sort=sort)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>var</th>\n",
       "      <th>vol_top5</th>\n",
       "      <th>vol_chg_top5</th>\n",
       "      <th>long_openIntr_top5</th>\n",
       "      <th>long_openIntr_chg_top5</th>\n",
       "      <th>short_openIntr_top5</th>\n",
       "      <th>short_openIntr_chg_top5</th>\n",
       "      <th>vol_top10</th>\n",
       "      <th>vol_chg_top10</th>\n",
       "      <th>...</th>\n",
       "      <th>long_openIntr_chg_top15</th>\n",
       "      <th>short_openIntr_top15</th>\n",
       "      <th>short_openIntr_chg_top15</th>\n",
       "      <th>vol_top20</th>\n",
       "      <th>vol_chg_top20</th>\n",
       "      <th>long_openIntr_top20</th>\n",
       "      <th>long_openIntr_chg_top20</th>\n",
       "      <th>short_openIntr_top20</th>\n",
       "      <th>short_openIntr_chg_top20</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CF</td>\n",
       "      <td>CF</td>\n",
       "      <td>52888</td>\n",
       "      <td>-75857</td>\n",
       "      <td>84865</td>\n",
       "      <td>1109</td>\n",
       "      <td>98835</td>\n",
       "      <td>-960</td>\n",
       "      <td>78662</td>\n",
       "      <td>-121354</td>\n",
       "      <td>...</td>\n",
       "      <td>-646</td>\n",
       "      <td>207387</td>\n",
       "      <td>1678</td>\n",
       "      <td>107296</td>\n",
       "      <td>-161507</td>\n",
       "      <td>202961</td>\n",
       "      <td>-505</td>\n",
       "      <td>236944</td>\n",
       "      <td>-438</td>\n",
       "      <td>20181105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CF811</td>\n",
       "      <td>CF</td>\n",
       "      <td>105</td>\n",
       "      <td>20</td>\n",
       "      <td>1471</td>\n",
       "      <td>-25</td>\n",
       "      <td>1840</td>\n",
       "      <td>-17</td>\n",
       "      <td>114</td>\n",
       "      <td>-206</td>\n",
       "      <td>...</td>\n",
       "      <td>-33</td>\n",
       "      <td>1910</td>\n",
       "      <td>-17</td>\n",
       "      <td>114</td>\n",
       "      <td>-206</td>\n",
       "      <td>1910</td>\n",
       "      <td>-33</td>\n",
       "      <td>1910</td>\n",
       "      <td>-17</td>\n",
       "      <td>20181105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CF901</td>\n",
       "      <td>CF</td>\n",
       "      <td>38625</td>\n",
       "      <td>-42188</td>\n",
       "      <td>40853</td>\n",
       "      <td>304</td>\n",
       "      <td>59685</td>\n",
       "      <td>-1427</td>\n",
       "      <td>55264</td>\n",
       "      <td>-65881</td>\n",
       "      <td>...</td>\n",
       "      <td>-1454</td>\n",
       "      <td>110321</td>\n",
       "      <td>-2401</td>\n",
       "      <td>76449</td>\n",
       "      <td>-98875</td>\n",
       "      <td>103849</td>\n",
       "      <td>-2870</td>\n",
       "      <td>122157</td>\n",
       "      <td>-2315</td>\n",
       "      <td>20181105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CF905</td>\n",
       "      <td>CF</td>\n",
       "      <td>16933</td>\n",
       "      <td>-36269</td>\n",
       "      <td>47771</td>\n",
       "      <td>174</td>\n",
       "      <td>56604</td>\n",
       "      <td>297</td>\n",
       "      <td>24048</td>\n",
       "      <td>-47348</td>\n",
       "      <td>...</td>\n",
       "      <td>506</td>\n",
       "      <td>106350</td>\n",
       "      <td>1624</td>\n",
       "      <td>32614</td>\n",
       "      <td>-61733</td>\n",
       "      <td>97675</td>\n",
       "      <td>584</td>\n",
       "      <td>117668</td>\n",
       "      <td>1579</td>\n",
       "      <td>20181105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CF909</td>\n",
       "      <td>CF</td>\n",
       "      <td>1920</td>\n",
       "      <td>-1111</td>\n",
       "      <td>9545</td>\n",
       "      <td>232</td>\n",
       "      <td>7950</td>\n",
       "      <td>-463</td>\n",
       "      <td>2593</td>\n",
       "      <td>-1463</td>\n",
       "      <td>...</td>\n",
       "      <td>246</td>\n",
       "      <td>13461</td>\n",
       "      <td>-536</td>\n",
       "      <td>3093</td>\n",
       "      <td>-1801</td>\n",
       "      <td>13933</td>\n",
       "      <td>240</td>\n",
       "      <td>14516</td>\n",
       "      <td>-526</td>\n",
       "      <td>20181105</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   symbol var  vol_top5  vol_chg_top5  long_openIntr_top5  \\\n",
       "0      CF  CF     52888        -75857               84865   \n",
       "1  CF811   CF       105            20                1471   \n",
       "2  CF901   CF     38625        -42188               40853   \n",
       "3  CF905   CF     16933        -36269               47771   \n",
       "4  CF909   CF      1920         -1111                9545   \n",
       "\n",
       "   long_openIntr_chg_top5  short_openIntr_top5  short_openIntr_chg_top5  \\\n",
       "0                    1109                98835                     -960   \n",
       "1                     -25                 1840                      -17   \n",
       "2                     304                59685                    -1427   \n",
       "3                     174                56604                      297   \n",
       "4                     232                 7950                     -463   \n",
       "\n",
       "   vol_top10  vol_chg_top10    ...     long_openIntr_chg_top15  \\\n",
       "0      78662        -121354    ...                        -646   \n",
       "1        114           -206    ...                         -33   \n",
       "2      55264         -65881    ...                       -1454   \n",
       "3      24048         -47348    ...                         506   \n",
       "4       2593          -1463    ...                         246   \n",
       "\n",
       "   short_openIntr_top15  short_openIntr_chg_top15  vol_top20  vol_chg_top20  \\\n",
       "0                207387                      1678     107296        -161507   \n",
       "1                  1910                       -17        114           -206   \n",
       "2                110321                     -2401      76449         -98875   \n",
       "3                106350                      1624      32614         -61733   \n",
       "4                 13461                      -536       3093          -1801   \n",
       "\n",
       "   long_openIntr_top20  long_openIntr_chg_top20  short_openIntr_top20  \\\n",
       "0               202961                     -505                236944   \n",
       "1                 1910                      -33                  1910   \n",
       "2               103849                    -2870                122157   \n",
       "3                97675                      584                117668   \n",
       "4                13933                      240                 14516   \n",
       "\n",
       "   short_openIntr_chg_top20      date  \n",
       "0                      -438  20181105  \n",
       "1                       -17  20181105  \n",
       "2                     -2315  20181105  \n",
       "3                      1579  20181105  \n",
       "4                      -526  20181105  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fushare.get_rank_sum(date = '20181105', vars = ['CF']) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "20180618非交易日\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180619.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180620.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180621.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180622.dat HTTP Error 403: Forbidden\n",
      "20180623非交易日\n",
      "20180624非交易日\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180625.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180626.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180627.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180628.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180629.dat HTTP Error 403: Forbidden\n",
      "20180630非交易日\n",
      "20180701非交易日\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180702.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180703.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180704.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180705.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180706.dat HTTP Error 403: Forbidden\n",
      "20180707非交易日\n",
      "20180708非交易日\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180709.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180710.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180711.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180712.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180713.dat HTTP Error 403: Forbidden\n",
      "20180714非交易日\n",
      "20180715非交易日\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180716.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180717.dat HTTP Error 403: Forbidden\n",
      "http://www.shfe.com.cn/data/dailydata/kx/kx20180718.dat HTTP Error 403: Forbidden\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYwAAAD8CAYAAABkbJM/AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xl8VeWd+PHPNzsJIRAIISFAAMMS2YQUwbpUAQVsAa0LjFo6XdC29tVlOi2dzvxedmbaceqM3bSt1HZKq9ZSLQUrGoFqXVGQsgUSEvaQhbAkJJA9398f9wQveJN7k3vD3b7v1+u+7lmec+43DyTf+5znPOcRVcUYY4zxJibYARhjjAkPljCMMcb4xBKGMcYYn1jCMMYY4xNLGMYYY3xiCcMYY4xPLGEYY4zxiSUMY4wxPrGEYYwxxidxwQ4gkIYMGaK5ubnBDsMYY8LK+++/f1JVM7yVi6iEkZuby7Zt24IdhjHGhBUROeJLObskZYwxxieWMIwxxvjEEoYxxhifWMIwxhjjE0sYxhhjfGIJwxhjjE8sYRhjjPGJJQxjTFQ5UNPAo6+UUH22KdihhB2/EoaIpIvIRhEpdd4HdVFuvoiUiEiZiKx0236niBSJSIeIFHg4bqSINIjIN/yJ0xhjOu0ur+Mnfy2jobkt2KGEHX9bGCuBzaqaB2x21i8iIrHA48ACIB9YJiL5zu49wO3A612c/1HgJT9jNMaYCyrqGgHISksKciThx9+EsRhY7SyvBpZ4KDMTKFPVg6raAjzrHIeq7lPVEk8nFpElwCGgyM8YjTHmgsraJtL6xZOcEFFPRros/E0Ymapa6SxXAZkeygwHjrmtlzvbuiQi/YFvAd/1FoCIrBCRbSKyraamxreojTFRq7Ku0VoXveQ1xYrIJmCYh13fcV9RVRURDVBcDwE/VNUGEem2oKquAlYBFBQUBOrzjTERqqK2ieyB/YIdRljymjBUdW5X+0SkWkSyVLVSRLKAEx6KHQdGuK3nONu6czVwh4j8ABgIdIhIk6o+5i1eY4zpTmVdI1eNHBjsMMKSvxfx1gPLgYed93UeymwF8kRkNK5EsRT4h+5OqqrXdS6LyENAgyULY4y/GlvaOXO+1VoYveRvH8bDwDwRKQXmOuuISLaIbABQ1TbgQaAQ2AesUdUip9xtIlIOzAZeFJFCP+MxxpguVdodUn7xq4WhqqeAOR62VwAL3dY3ABs8lFsLrPXyGQ/5E6MxxnSqrHMN1stKsxZGb9hIb2NM1OhMGNkDrYXRG5YwjDFRo7LWdUkqc4AljN6whGGMiRoVdU0MTkkgKT422KGEJUsYxpioUVnXSJZdjuo1SxjGmKhRWdtkHd5+sIRhjIkaFXWNZNsttb1mCcMYExUamtuob2ojywbt9ZolDGNMVOi8Q8oG7fWeJQxjTFSouDAGw1oYvWUJwxgTFayF4T9LGMaYqFBR14SIDdrzhyUMY0xUqKprZGhqIvGx9mevt6zmjDFRobLOxmD4yxKGMSYqVNTa1Kz+soRhjIl4qmotjACwhGGMiXhnG9s439JujzX3kyUMY0zEq7gw0561MPxhCcMYE/EuTM1qLQy/+JUwRCRdRDaKSKnzPqiLcvNFpEREykRkpdv2O0WkSEQ6RKTAbXuuiDSKyA7n9Qt/4jTGRLeKWmeUt7Uw/OJvC2MlsFlV84DNzvpFRCQWeBxYAOQDy0Qk39m9B7gdeN3DuQ+o6jTn9YCfcV52ZScaWPTYm2w/eibYoRgT9SrrGomLETJSE4MdSljzN2EsBlY7y6uBJR7KzATKVPWgqrYAzzrHoar7VLXEzxhC0sMv7WNXeR3fWLOTptb2YIdjTFSrrG0ic0ASsTES7FDCmr8JI1NVK53lKiDTQ5nhwDG39XJnmzejnctRfxOR6/yM87J69+ApNu07wbz8TA6ePMePNpUGOyRjolpFnY3BCASvCUNENonIHg+vxe7lVFUBDVBclcBIVZ0GfB14RkQGdBHfChHZJiLbampqAvTxvaeq/NdLxQwbkMRPl13F3QUj+OUbB9ldXhfs0IyJWlV1TTYPRgB4TRiqOldVJ3l4rQOqRSQLwHk/4eEUx4ERbus5zrbuPrNZVU85y+8DB4BxXZRdpaoFqlqQkZHh7cfpcy/tqWLHsVq+Pm8cSfGx/MutExnSP4F/fm4nLW0dwQ7PmKjzwaA9a2H4y99LUuuB5c7ycmCdhzJbgTwRGS0iCcBS57guiUiG01mOiIwB8oCDfsba51rbO3iksIRxmf355IwcANL6xfO9JZMprqrn568dCHKExkSf0+daaG7rsIQRAP4mjIeBeSJSCsx11hGRbBHZAKCqbcCDQCGwD1ijqkVOudtEpByYDbwoIoXOea8HdonIDuA54AFVPe1nrH3u2feOcujkOb41f8JFnWtz8zNZNDWbx14tpaSqPogRGhN9Kp2Jk2zQnv/i/DnYuWw0x8P2CmCh2/oGYIOHcmuBtR62Pw88709sl1tDcxs/2lTK1aPTuWnC0A/tf2jRlbxVdpJvPreT579wDXH2iGVjLosKZ+IkeyyI/+yvVoCsev0gp8618O2FExH58K176SkJPLToSnaW1/Hrtw4FIUJjopO1MALHEkYAnKhv4sk3DnLr5CymjRjYZbmPT8liXn4m//vKfg6dPHcZIzQmelXUNZIQG8PglIRghxL2LGEEwI83ldLS1sE/3zK+23Iiwn8umURCXAzfen4XHR2BugvZGNOVytomhqUlEWOD9vxmCcNPB2oaeHbrMe65eiS5Q1K8ls8ckMS/fTyf9w6d5ul3j1yGCI2JbpU2aC9gLGH46QcvF5MUF8OX5+T5fMydM3K4Lm8ID79UTPmZ830YnTGmoraJbBu0FxCWMPzw/pHTFBZVc/8NYxnS3/eHmokI379tMgr8y9o9uAbJG2MCraNDqT5rg/YCxRJGL6kq399QTEZqIp+7bnSPjx+RnszKBRN4fX8Nz71f3gcRGmNONjTT1qGWMALEEkYvvbK3mvePnOGrc/NITujdcJZ7rx7FzNx0/uMvezlxtinAERpjKuyW2oCyhNELbe0d/ODlYsZkpHB3wQjvB3QhJkZ4+JOTaW7r4N/W2aUpYwKtstZm2gskv0Z6R4ra8y389p0jjB+WyvjMVEamJ3d7C96abeUcqDnHE/fN8HvE9piM/nxr/gRa2jtQBQ9j/owxvdTZwrCZ9gLDEgau2fEe3bj/wnq/+FjyMvszPjPVlUScRJKRmkhjazs/3LSfGaMGcXO+p+k/eu4z1/a8D8QY411lbSNJ8TEMTI4PdigRwRIGUJCbTtF3b2F/dT37q+sprnK9v1pSwx/dOqQHJceTnpJATX0zv7h3usdHgBhjQkdlXRPZaf3sdzVALGE4UhLjuGrkIK4aOeii7acamimprqek6oNk8ulrcpkxKj1IkRpjfFVR12j9FwFkCcOLwf0TuaZ/IteMHRLsUIwxPVRZ28S1efa7Gyh2l5QxJiK1tXdwor6JbBuDETCWMIwxEam6vpkOxebyDiBLGMaYiFRV5xqDMcxaGAFjCSPK7a04y52/eJtK55fLmEhRUWtjMALNEkaUG9Avjh3Hann81bJgh2JMQHV+CbK7pALHr4QhIukislFESp33QV2Umy8iJSJSJiIr3bbfKSJFItIhIgWXHDNFRN5x9u8WEftX7wM5g5K5+yMj+MPWY/aodRNRKmqb6J8Yx4AkG7QXKP62MFYCm1U1D9jsrF9ERGKBx4EFQD6wTETynd17gNuB1y85Jg54CnhAVa8EPga0+hmr6cKXbrwCQayVYSKKTZwUeP4mjMXAamd5NbDEQ5mZQJmqHlTVFuBZ5zhUdZ+qlng45mZgl6rudMqdUtV2P2M1XchK68c/XD2SP24r5+gpa2WYyFBZ12R3SAWYvwkjU1UrneUqwNPDlYYDx9zWy51t3RkHqIgUish2EflmVwVFZIWIbBORbTU1NT2J3bj5wsfGEhsj/PSvpcEOxZiAqKi1MRiB5jVhiMgmEdnj4bXYvZy6ns0dqOdzxwHXAvc477eJyBxPBVV1laoWqGpBRkZGgD4++mQOSOLeWaP409+Pc+jkuWCHY4xfmtvaOdnQbPNgBJjXhKGqc1V1kofXOqBaRLIAnPcTHk5xHHCfNCLH2dadcuB1VT2pqueBDcB0X34g03sP3DCW+Fjhp5utlWHCW3VdM2B3SAWav5ek1gPLneXlwDoPZbYCeSIyWkQSgKXOcd0pBCaLSLLTAX4DsNfPWI0XGamJLJ+dy593HKfsREOwwzGm1yqcW2ptDEZg+ZswHgbmiUgpMNdZR0SyRWQDgKq2AQ/iSgL7gDWqWuSUu01EyoHZwIsiUugccwZ4FFey2QFsV9UX/YzV+GDF9WNIio/lJ9bKMGGs0kZ59wm/nlarqqeAD/UtqGoFsNBtfQOuy0qXllsLrO3i3E/hurXWXEaD+yfy6Wty+fnfDvDgTVcwLjM12CEZ02OVnTPt2SWpgLKR3uZDPn/dGFIS4vjxJmtlmPBUWdtEWr94khNsBodAsoRhPmRQSgKf+WguL+6uZF/l2WCHY0yP2aC9vmEJw3j02WvHkJoUx4827fde2JgQU1HbRLYN2gs4SxjGo7TkeD537RgKi6rZc7wu2OEY0yPWwugbljBMl/7x2lzS+sVbK8OElcaWds6cb7UWRh+whGG6NCApnhXXj2HTvhPsPFYb7HCM8cmFx5pbCyPgLGGYbi2/JpdByfH80FoZJkx03lJrjwUJPEsYplv9E+NYcf1YXiup4f0jZ4IdjjFeVdQ6o7xtDEbAWcIwXn1q9igGpyRYX4YJC50tjMwBljACzRKG8SolMY4HbhjLG6Unee/Q6WCHY0y3KuuaGJySQFJ8bLBDiTiWMIxP7p01iiH9E/nfV0pwPcnemNBUWddoT6ntI5YwjE/6JcTypRvH8u6h07x94FSwwzGmS5W1Tdbh3UcsYRifLZs5kqy0JGtlmJBWUddoM+31EUsYxmdJ8bF8+aY8th+t5bWSyzsd7ulzLXzp6e1Un226rJ9rwktDcxv1TW02l3cfsYRheuTOghxGpifzP5exldHS1sEDT73Pxn3VF+6AMcaTylobtNeXLGGYHomPjeErc/IoqjhLYVFVn3+eqvL/1u3hvUOneeSOKUwbMbDPP9OEr4oL82BYC6MvWMIwPbbkquGMzUjh0Y37ae/o21bG/711mGe3HuNLN45l8bThffpZJvxZC6NvWcIwPRYbI3xt3jj2Vzfwl10VffY5f9tfw3++uJeb8zP5p3nj++xzTOSoqGtCxAbt9RW/EoaIpIvIRhEpdd4HdVFuvoiUiEiZiKx0236niBSJSIeIFLhtv0dEdri9OkRkmj+xmsBaOCmLCcNS+eHG/bS1dwT8/GUnGnjwme2My0zlh3dPIyZGAv4ZJvJU1jaS0T+R+Fj7LtwX/K3VlcBmVc0DNjvrFxGRWOBxYAGQDywTkXxn9x7gduB192NU9WlVnaaq04D7gEOqusPPWE0AxcQI/3TzeA6fOs+fth8P6Llrz7fwudVbSYyL4cnlBaQk2jSbxjeVdU12h1Qf8jdhLAZWO8urgSUeyswEylT1oKq2AM86x6Gq+1S1xMtnLHOOMSFm7sShTM1J48ebS2luaw/IOVvbO/ji09upqG3iiftmkDMoOSDnNdGh0sZg9Cl/E0amqlY6y1VApocyw4FjbuvlzjZf3Q38vnfhmb4k4mplHK9tZM3WY94P8MG/v7CXtw+c4vu3T2bGqPSAnNNEB1V1tTBslHef8ZowRGSTiOzx8FrsXk5dN+UH9JYZEbkaOK+qe7ops0JEtonItpqayzuYzMB1eUOYmZvOT/9aRlOrf62M371zmN9tOcL914/hjhk5gQnQRI2zjW2cb2m3x5r3Ia8JQ1XnquokD691QLWIZAE47yc8nOI4MMJtPcfZ5ouleGldqOoqVS1Q1YKMjAwfT2sCxdXKGMeJ+mae2nKk1+d5q+wkD72wlzkThvLN+RMCGKEJZ6rK0VPnfRokWnFhpj1rYfQVfy9JrQeWO8vLgXUeymwF8kRktIgk4EoC672dWERigLuw/ouQd/WYwVyXN4SfvXaAc81tPT7+0MlzfPHp7YzNSOFHS6cRa3dEGUdhUTXXP/IqC378Bmu2Heu2r+zC1KzWwugz/iaMh4F5IlIKzHXWEZFsEdkAoKptwINAIbAPWKOqRU6520SkHJgNvCgihW7nvh44pqoH/YzRXAZfnzeO0+da+M3bh3t0XF1jK59dvZUYgSc/9RFSk+L7JkATll7YVcHAZNf/iW8+t4uPPvwqP9lcyqmG5g+Vrah1RnlbC6PP+HW/oqqeAuZ42F4BLHRb3wBs8FBuLbC2i3O/BszyJz5z+Vw1chBzJw7lib8d4N5Zo0jr1/0f/obmNv789+P85u3DHD11nqc/dzUjB9sdUeYDTa3tvFZ8gkXThvP92ybxVtkpnnzzII9u3M/jr5Zx+/QcPnttLlcMTQVcLYy4GCEjNTHIkUcuu8HdBMzX5o3j1p+8ya/eOMjXb/Y8MntvxVmeevcI6/5+nHMt7eRnDeAX987g6jGDL3O0JtS9VXaScy3tzJ80DBHh2rwhXJs3hNLqen791iGe317O7987ysfGZ/C5a8dQUdtE5oAku6TZhyxhmIC5MjuNWydn8as3D/Hpj44mPSUBcH1T/MuuSp5+9wh/P1pLYlwMn5iazT1Xj2TaiIGI2C+4+bDCoipSk+KYfcmXibzMVP7r9il84+bxPLXlKL/bcph7f/UuIjB9pMeHTZgAsYRhAupr8/J4aU8lT/ztAHd9ZATPvHuU594vp66xlTEZKfzbx/O5Y3oOacnWV2G61tbewca91cyZMJSEOM9drYP7J/KVuXncf8MY1u+s4KktR7hxvN0p2ZcsYZiAumJoKkumDefJNw/xxOsHiY8VbrlyGPdcPYpZY9KtNWF8svXwGc6cb+WWK4d5LZsUH8tdBSO4q2CE17LGP5YwTMB9bd44quubuGbsEO4qGGGdkKbHCouqSIyL4QZrMYQUSxgm4EakJ/P05+wGN9M7qkphURXXj8sgOcH+RIUSewawMSak7Cqvo7Kuifk+XI4yl5clDGNMSHm5qIq4GGHOxKHBDsVcwhKGMSZkqCqFe6qYNWYwA5MTgh2OuYQlDGNMyCg70cDBk+e4ZZJdjgpFljCMMSGjsKgKgJvzPU2tY4LNEoYxJmS8XFTF9JEDyRxgT5wNRZYwjDEhofzMefYcP+vTYL1wdraplfIz54MdRq9YwjDGhITComqAiE4YHR3Kgh+9wX/+ZV+wQ+kVSxjGmJBQWFTFhGGp5A5JCXYofSYmRvj41Cw27qumqq4p2OH0mCUMY0zQ1dQ3s/Xw6YhuXXS6Z+YoOlT5/XtHgx1Kj1nCMMYE3aZ91ahG9uWoTiMHJ3PDuAx+/95RWts7gh1Oj1jCMMYEXWFRFSPTk5mYlRrsUC6L+2aN4kR9Mxv3Vgc7lB6xhGGMCaqzTa28VXaSW67MjJrH339s/FCGD+zH7945EuxQesSvhCEi6SKyUURKnXeP012JyHwRKRGRMhFZ6bb9ThEpEpEOESlw2x4vIqtFZLeI7BORb/sTpzEmdL1afILWdmV+FI3ujo0R7pk1kncOnqLsRH2ww/GZvy2MlcBmVc0DNjvrFxGRWOBxYAGQDywTkXxn9x7gduD1Sw67E0hU1cnADOB+Ecn1M1ZjTAgqLKoiIzWRq0ZE1/SqdxWMICE2hqe2hE/nt78JYzGw2lleDSzxUGYmUKaqB1W1BXjWOQ5V3aeqJR6OUSBFROKAfkALcNbPWI0xIaaptZ3XSmq4OT+TmJjouBzVaUj/RBZOHsbz75dzrrkt2OH4xN+Ekamqlc5yFeDpATDDgWNu6+XOtu48B5wDKoGjwP+o6mlPBUVkhYhsE5FtNTU1PQreGBNcb5Se5HxLe1TcHeXJfbNHUd/cxvqdFcEOxSdeE4aIbBKRPR5ei93LqariahkEwkygHcgGRgP/JCJjPBVU1VWqWqCqBRkZNp2jCR9P/O0Af9x2zHvBCPbynioGJMUxa8zgYIcSFNNHDmJi1gB+984RXH9CQ5vXhKGqc1V1kofXOqBaRLIAnPcTHk5xHHCfnT3H2dadfwBeVtVWVT0BvAUUeDnGmLCxfmcF//VSMatePxjsUIKmtb2DzcXVzJmYSUJcdN6wKSLcN2sUeyvPsv1obbDD8crff6X1wHJneTmwzkOZrUCeiIwWkQRgqXNcd44CNwGISAowCyj2M1ZjQkLZiXpWPr+LuBjhQE0D51vC4/p1oL136DS151uj9nJUp8XTsumfGMdTW0L/Flt/E8bDwDwRKQXmOuuISLaIbABQ1TbgQaAQ2AesUdUip9xtIlIOzAZeFJFC57yPA/1FpAhXwvk/Vd3lZ6zGBN35lja+8NR2kuJjeWjRlXQo7K2Izvs5CouqSIqP4YZx0X0pOSUxjk9OH86Luyo51dAc7HC65VfCUNVTqjpHVfOcS1enne0VqrrQrdwGVR2nqmNV9Xtu29eqao6qJqpqpqre4mxvUNU7VfVKVc1X1Uf8idMYf63bcZxNfo7KVVW+s3YPZTUN/HjpNOY5kwTtPl4XiBDDSkeHUlhUxQ3jMuiXEBvscILu3lmjaGnvYM228mCH0q3ovHBoTA90dCi/fecI9z/1Pmu29r6T+vfvHWPt34/zlTl5XJeXQeaAJDJSE6MyYewsr6X6bHPUX47qlJeZyqwx6Tzz3hHaO3re+d3Y0k5LW98/l8oShjFexMQIv/3MTK4ZO5hvPr+Lx18t6/EdLXuO1/HQC0VclzeEL9+Ud2H75OFp7InChPFyURVxMcKcCTYVa6f7ZuVy7HQjr+/v2fCAkw3NLP3lFv71z7v7KLIPWMIwxgcpiXH8avlHWDItm0cKS/juC3vp8PGbYF1jK198ejvpyQn86O5pxLoNUJs0PI2yE9HX8f23khquHpNOWnJ8sEMJGTdfmUlGaiK/60Hn94GaBm772VuUVJ1l7sS+T76WMIzxUUJcDI/eNY3PXjua37x9mK/8YQfNbe3dHqOq/PMfd1JR28jj91zF4P6JF+2fPDwt6jq+W9o6KDvRwJScgcEOJaTEx8awbOZIXi05wbHT3qdw3Xr4NJ/8+ducb27n2RWzufkyXN6zhGFMD8TECP9660S+vWACL+ys4LO/2UZDN491ePKNQ7yyt5qVCyYwY1T6h/ZPyUkDoqvj+0BNA20dyoRh0fEo855YNnMEMSI8/W73z5d6cVcl9zz5LunJCaz94keZNuLyJF9LGMb0kIhw/w1j+Z87p/LOwVMsW7WFkx5uh9x6+DQPv1zM/CuH8dlrR3s8VzR2fJdUuZ7OOmHYgCBHEnqy0voxd+JQ1mw7RlPrh1uvqsqq1w/wpWe2M2V4Gs9/4RpGDk6+bPFZwjCml+6YkcMvPzWD0hP13PHztzl66oPLCCcbmnnwme3kDOrHD+6c0u08D9HW8V1cVU98rDAmI3Ln7vbHfbNyOX2uhZf2VF60vb1DeWh9Ed/fUMytk7N46nNXMygl4bLGZgnDGD/cNCGTZz4/i9rGVm7/+dsUVdTR3qF89dkdnDnfys/umc6ApO47dqOt47u46ixjM/oTH2t/fjy5ZuxgxgxJueix540t7dz/u/dZ/c4RVlw/hp8uu4qk+Ms/fsX+xYzx0/SRg3jugdkkxAp3P7GFr/1hB2+WneQ/Fl/JldlpXo/v7PjeVxkdHd8lVfXWf9GNmBjhnlmjeP/IGYoq6i7cNvvX4mq+u+hK/mXhxKA9Ct4ShjEBcMXQVJ7/4jVkpSWxfmcFn5yew10FI7wfiCthAOwuj/zLUnXnW6msa2K89V90647pOSTFx/DoK/sv3Db7i3tnsPya3KDGFRfUTzcmgmSl9eOPD8zmL7sq+eT0HJ/np84ckMiQ/onsPh75LYziKtfPOCHLWhjdSUuOZ/HU4fxh2zEGpyTw7IrZl+1OqO5YwjAmgAYmJ3DvrFE9OkZEmDx8QFR0fJdUd94hZQnDmy/deAWt7R18de64y3onVHfskpQxIWDy8DRKT9TT2NL9QMBwV1xVz4CkOIYNSAp2KCFv5OBkHr17WsgkC7CEYUxImNQ54jvCO76LK88yIWuAz5frTGixhGFMCJjsjPiO5MtSqsr+6ga7HBXGLGEYEwKGDUhiSP8EdkXwnVLlZxppaG5jvCWMsGUJw5gQICJMivAR3/ZIkPBnCcOYEBHpHd+dt9RaCyN8+ZUwRCRdRDaKSKnzPqiLcvNFpEREykRkpdv2O0WkSEQ6RKTAbXuCiPyfiOwWkZ0i8jF/4jQmHEyO8I7v4qp6cgb1o3+i3c0frvxtYawENqtqHrDZWb+IiMQCjwMLgHxgmYjkO7v3ALcDr19y2OcBVHUyMA/4XxGx1pCJaJHe8W2PBAl//v4RXgysdpZXA0s8lJkJlKnqQVVtAZ51jkNV96lqiYdj8oG/OmVOALVAgYdyxkSMzo7vSHzUeXNbOwdPnrP+izDnb8LIVNXOZ/BWAZ7mCBwOHHNbL3e2dWcnsEhE4kRkNDAD8O3BPMaEqUju+C470UB7h1r/RZjzejFRRDYBnub++477iqqqiPg2ybF3vwYmAtuAI8DbgMeeQBFZAawAGDlyZIA+3pjgmDw8jTdKT9LU2h6Ux1f3lQ/ukLKEEc68JgxVndvVPhGpFpEsVa0UkSzghIdix7m4dZDjbOvuM9uAr7l9ztvA/i7KrgJWARQUFAQqYRkTFJOGp9HeoeytPMv0kR7vIQlLxVX1JMTGMHqITZoUzvy9JLUeWO4sLwfWeSizFcgTkdEikgAsdY7rkogki0iKszwPaFPVvX7GakzI63zUeaRdliququeKof2Js0mTwpq//3oPA/NEpBSY66wjItkisgEutBYeBAqBfcAaVS1yyt0mIuXAbOBFESl0zjsU2C4i+4BvAff5GacxYSErLYnBKQkRNzdGSdVZuxwVAfy6IVpVTwFzPGyvABa6rW8ANngotxZY62H7YWC8P7EZE446O74j6U6pM+daqD7bbHNgRABrHxoTYlwjvhtoao2MEd/FToe3zbIX/iyMr3z9AAAOIklEQVRhGBNi3Du+I0FJ5yx7dkkq7FnCMCbERNqI7+KqegYlxzM0NTHYoRg/WcIwJsRkpyWRHkEd38VV9YwflmqTJkUASxjGhJhI6vju6FD2V9fbI0EihCUMY0LQlAjp+D525jznW9qt/yJCWMIwJgR1dnzvC/OO7w/ukLKEEQksYRgTgiKl47vzGVLjMi1hRAJLGMaEoAsd32GeMIqrzjJqcDIpNmlSRLCEYUwI+qDjO/wvSY231kXEsIRhTIiaPHwApdX1Ydvx3dTazuGT56zDO4JYwjAmRE0enkZbh17oOA43pdUNdChMyLJbaiOFJQxjQtQk51Hn4dqPUew8EsTukIocljCMCVHDB/ZjUHI8u8trgx1Kr5RU1ZMYF0PuYJs0KVJYwjAmRIV7x3dxVT15mf2JjbFHgkQKSxjGhLDJw9PCtuO7uMoeCRJpLGEYE8LCteP7ZEMzJxua7Q6pCGMJw5gQFq4d3yX2SJCIZAnDmBCWM6gfA5Pj2RNmjzrvbBHZJanI4lfCEJF0EdkoIqXO+6Auys0XkRIRKRORlW7bHxGRYhHZJSJrRWSg275vO+VLROQWf+I0JlyJCJPD8FHnJVVnGZySQIZNmhRR/G1hrAQ2q2oesNlZv4iIxAKPAwuAfGCZiOQ7uzcCk1R1CrAf+LZzTD6wFLgSmA/8zDmPMVFn8vA09odZx3fnpEkmsvibMBYDq53l1cASD2VmAmWqelBVW4BnneNQ1VdUtc0ptwXIcTvvs6rarKqHgDLnPMZEnSk5ro7vcHlybbtNmhSx/E0Ymapa6SxXAZkeygwHjrmtlzvbLvUZ4KUeHoOIrBCRbSKyraampiexGxMWZo8dQkJsDC/urvReOAQcPX2eptYOu0MqAnlNGCKySUT2eHgtdi+nqgpob4IQke8AbcDTPT1WVVepaoGqFmRkZPTm440JaWn94vnY+Az+squS9o5e/YpdVsWV9kiQSOX1IfWqOrerfSJSLSJZqlopIlnACQ/FjgMj3NZznG2d5/g08HFgjpN0vB5jTLRZNC2bV/ZW8+7BU1xzxZBgh9Ot4qp6RGzSpEjk7yWp9cByZ3k5sM5Dma1AnoiMFpEEXJ3Z68F19xTwTWCRqp6/5LxLRSRRREYDecB7fsZqTNiaMyGT5IRYXthVEexQvCqpqid3cAr9Euw+lUjjb8J4GJgnIqXAXGcdEckWkQ0ATqf2g0AhsA9Yo6pFzvGPAanARhHZISK/cI4pAtYAe4GXgS+pavjcImJMgPVLiGVefiYbdlfR0tYR7HC6VVx11iZNilB+zZuoqqeAOR62VwAL3dY3ABs8lLuim3N/D/ieP/EZE0kWTc1m3Y4K3iitYc5ET/eXBN/5ljaOnD7Pkqs83qNiwpyN9DYmTFyXl0Fav3he2Bm6l6VKqxtQxe6QilCWMIwJEwlxMSyYNIxX9lbT2BKaV2g/mDTJxmBEIksYxoSRRVOzOd/Szubi6mCH4lFxVT394mMZmZ4c7FBMH7CEYUwYuXrMYIamJrJ+R2heliqpqmecTZoUsSxhGBNGYmOEW6dk8VpJDWebWoMdzkVU1Z4hFeEsYRgTZj4xNZuW9g4K91QFO5SL1DQ0c/pciz1DKoJZwjAmzFw1YiAj0vuxPsTuliq5MAeGtTAilSUMY8KMiPCJKdm8feAUJxuagx3OBcMGJHH/DWOYmGUtjEhlCcOYMPSJqdm0dygvhdATbPMyU/n2gokMSkkIdiimj1jCMCYMTRiWSt7Q/iF3WcpENksYxoQhEWHR1Gy2Hj7D8drGYIdjooQlDGPC1CemZgPwYhg8wdZEBksYxoSp3CEpTMlJs8tS5rKxhGFMGFs0NZs9x89ysKYh2KGYKGAJw5gw9vEp2YjACztD524pE7ksYRgTxoalJTEzN531O4/zwQzHxvQNSxjGhLlPTM3mQM059laeDXYoJsJZwjAmzC2cnEVcjFjnt+lzfiUMEUkXkY0iUuq8D+qi3HwRKRGRMhFZ6bb9EREpFpFdIrJWRAY62weLyKsi0iAij/kTozGRLj0lgWvzhvCXnZV2Wcr0KX9bGCuBzaqaB2x21i8iIrHA48ACIB9YJiL5zu6NwCRVnQLsB77tbG8C/g34hp/xGRMVFk3N5nhtI9uPngl2KCaC+ZswFgOrneXVwBIPZWYCZap6UFVbgGed41DVV1S1zSm3Bchxtp9T1TdxJQ5jjBfz8jNJjIsJ2YmVTGTwN2Fkqmrn/XxVQKaHMsOBY27r5c62S30GeMnPeIyJSqlJ8dw0YSgv7q6krb0j2OGYCOU1YYjIJhHZ4+G12L2cui6e9uoCqoh8B2gDnu7FsStEZJuIbKupqenNxxsTERZNzeZkQwtbDp4OdigmQsV5K6Cqc7vaJyLVIpKlqpUikgWc8FDsODDCbT3H2dZ5jk8DHwfmaC967FR1FbAKoKCgwHr8TNS6ccJQ+ifGsX7nca7NGxLscEwE8veS1HpgubO8HFjnocxWIE9ERotIArDUOQ4RmQ98E1ikquf9jMWYqJYUH8t9s0eROyQl2KGYCCX+3IYnIoOBNcBI4Ahwl6qeFpFs4ElVXeiUWwj8CIgFfq2q33O2lwGJwCnnlFtU9QFn32FgAJAA1AI3q+re7uIpKCjQbdu29frnMcaYaCQi76tqgbdyXi9JdUdVTwFzPGyvABa6rW8ANngod0U35871JzZjjDGBZSO9jTHG+MQShjHGGJ9YwjDGGOMTSxjGGGN8YgnDGGOMTyxhGGOM8YklDGOMMT7xa+BeqBGRGlwDCHtrCHAyQOFEKqsj76yOfGP15N3lqqNRqprhrVBEJQx/icg2X0Y7RjOrI++sjnxj9eRdqNWRXZIyxhjjE0sYxhhjfGIJ42Krgh1AGLA68s7qyDdWT96FVB1ZH4YxxhifWAvDGGOMT0I2YYjICBF5VUT2ikiRiHzF2Z4uIhtFpNR5H+RsH+yUbxCRxy451zIR2S0iu0TkZRHxOB2ZiMxwypWJyE9ERNz23eUWyzNdHH+9iGwXkTYRueOSff/tNr3t3f7Wj9t5w7Gevu6U2SUim0VklNu+kSLyiojsc8rkRlIdicgPRWSH89ovIrVdHJ8oIn9wjn+3sx5EZJTzf2yH87M84G/9hHk9dfc7t9yJuVRElns6PprrSERudDt+h4g0iciSbitAVUPyBWQB053lVGA/kA/8AFjpbF8J/LeznAJcCzwAPOZ2njhcU8cOcdZ/ADzUxWe+B8wCBHgJWOBszwP+Dgxy1od2cXwuMAX4LXCH2/ZbgY1OLCm4ZiEcEMX1dCOQ7Cx/AfiD277XgHnOcv/OcpFSR5eU+TKuCcU8Hf9F4BfO8tLOOsI1oViiW/0cBrIj7f9SD+opF8+/c+nAQed9kLM8yOrogzq6pEw6cBovv28h28JQ1UpV3e4s1wP7gOHAYmC1U2w1sMQpc05V3wSaLjmVOK8UJzMPACou/TxxzUk+QFW3qKsGf9t5buDzwOOqesb5LE9zl6Oqh1V1F9Bxya584HVVbVPVc8AuYL5vNdG9MK2nV/WDKXm34JrnHRHJB+JUdaNTrkEDMHVviNWRu2XA77sI2z2254A5IiKq2qKqzc72RAJ4lSAc66mb37lbgI2qetr5/7iRAPzORVgdubsDeMnb71vIJgx3TnP8KuBdIFNVK51dVUBmd8eqaiuub7G7cf2D5AO/8lB0OFDutl7ubAMYB4wTkbdEZIu45iLviZ3AfBFJdpqdNwIjengOr8K0nj6L61tT5/G1IvInEfm7iDwiIrE+nMNnIVBHnXGMAkYDf+3i44YDx5zPbQPqgMHOsSNEZJez/7/VNcNlQIVRPXXlQv11dW5/RUAduVtK119eLgj5hCEi/YHnga+q6ln3fU7G7fY2LxGJx/UPcxWQjevb/bd7GEYcrsstH8OVyX8pIgN9PVhVX8E1Re3buP5R3gHaexhDt8KxnkTkXqAAeMTt+OuAbwAfAcYAn+5hDF0KkTrqtBR4TlV7/P9AVY+p6hTgCmC5iHT7x6mnIqWe+lIk1ZHTipkMFHorG9IJw6nU54GnVfVPzuZq5wfs/EE9XvZwMw1AVQ84/5BrgGtEJNats+ffgeM4l0YcOc42cGX19araqqqHcF23zBOR73Wew9vPoqrfU9VpqjoPV1N0vw9V4JNwrCcRmQt8B1jkdomlHNihqgedb9V/Bqb3oko+JITqqNNF3+g81NFxnFaoiMQBacAp9xM4LYs9uJJsQIRhPXXlQv11c+5eiaA66nQXsNZp9XQrZBOGc13vV8A+VX3Ubdd6oPOOh+XAOi+nOg7ki0jng7XmOedsd/6AT1PV/+c0J8+KyCznsz/ldu4/4/rWjHNJaRxwUFW/03kOLz9LrIh0Xk6YgqsD6hVvdeCLcKwnEbkKeAJXsnD/xdoKDHSL4SZgr++14VmI1REiMgFXR+w7nds8/F9yj+0O4K+qqiKSIyL9nPMMwtWhWtKD6uhSmNZTVwqBm0VkkFNPN+PDN2hvIqyOOnXXl3YxDcDdFX3xwvWLoLiaajuc10Jc13E3A6XAJiDd7ZjDuHr6G3B9W813tj+Aq3NqF/ACMLiLzyzA9Y3tAPAYHwxsFOBRXH+8dgNLuzj+I87nnsP1bbDI2Z7kHLsXVyfvtCivp01AtVu86932zXM+fzfwGyAhkurI2fcQ8LCXmJOAPwJluO6SGXNJ/ex03ldE4v+lHtSTx985Z99nnPorA/7R6shjHeXiSl4xvvz8NtLbGGOMT0L2kpQxxpjQYgnDGGOMTyxhGGOM8YklDGOMMT6xhGGMMcYnljCMMcb4xBKGMcYYn1jCMMYY45P/D8pVqWc+gxJHAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0xb07cef0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-06-18</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-19</th>\n",
       "      <td>-0.015566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-20</th>\n",
       "      <td>-0.015632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-21</th>\n",
       "      <td>-0.014931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-22</th>\n",
       "      <td>-0.015514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-23</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-24</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-25</th>\n",
       "      <td>-0.015847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-26</th>\n",
       "      <td>-0.016599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-27</th>\n",
       "      <td>-0.017338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-28</th>\n",
       "      <td>-0.017183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-29</th>\n",
       "      <td>-0.016724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-30</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-01</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-02</th>\n",
       "      <td>-0.018217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-03</th>\n",
       "      <td>-0.018563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-04</th>\n",
       "      <td>-0.018063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-05</th>\n",
       "      <td>-0.019975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-06</th>\n",
       "      <td>-0.021076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-07</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-08</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-09</th>\n",
       "      <td>-0.020453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-10</th>\n",
       "      <td>-0.018298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-11</th>\n",
       "      <td>-0.017101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-12</th>\n",
       "      <td>-0.017270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-13</th>\n",
       "      <td>-0.013892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-14</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-15</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-16</th>\n",
       "      <td>-0.017686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-17</th>\n",
       "      <td>-0.018608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-18</th>\n",
       "      <td>-0.018274</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  ry\n",
       "2018-06-18       NaN\n",
       "2018-06-19 -0.015566\n",
       "2018-06-20 -0.015632\n",
       "2018-06-21 -0.014931\n",
       "2018-06-22 -0.015514\n",
       "2018-06-23       NaN\n",
       "2018-06-24       NaN\n",
       "2018-06-25 -0.015847\n",
       "2018-06-26 -0.016599\n",
       "2018-06-27 -0.017338\n",
       "2018-06-28 -0.017183\n",
       "2018-06-29 -0.016724\n",
       "2018-06-30       NaN\n",
       "2018-07-01       NaN\n",
       "2018-07-02 -0.018217\n",
       "2018-07-03 -0.018563\n",
       "2018-07-04 -0.018063\n",
       "2018-07-05 -0.019975\n",
       "2018-07-06 -0.021076\n",
       "2018-07-07       NaN\n",
       "2018-07-08       NaN\n",
       "2018-07-09 -0.020453\n",
       "2018-07-10 -0.018298\n",
       "2018-07-11 -0.017101\n",
       "2018-07-12 -0.017270\n",
       "2018-07-13 -0.013892\n",
       "2018-07-14       NaN\n",
       "2018-07-15       NaN\n",
       "2018-07-16 -0.017686\n",
       "2018-07-17 -0.018608\n",
       "2018-07-18 -0.018274"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import fushare as fushare\n",
    "fushare.get_rollYield_bar(type = 'date', start = '20180618', end = '20180718',plot = True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
